Greetings All,

I am new to this forum, so excuse me if I stumble. I must find a way
to accomplish the following: Search below a cell for the next matching
cell, and post all of the "unique" values included in the search,
including the matched value, post these adjacent to the referenced
cell. For example, given the following row:

2 - (This is my reference cell, the one I want to match)
6
5
5
7
4
3
3
2 - (this is my matched cell)

In the example above, I passed the values 6,5,7,4 and 3 before finding
the match of 2. I would like to be able to post in the cell directly
to the right of the reference cell the values 6,5,7,4,3,2 (yes I need
to include the referenced value). I could also accept a cumulative
total of unique values in the adjacent cell. In this case that value
would be 6 (6 unique values - I do not want a total of values, which
would be 8, because some values are repeats like 5 and 3). The
cumulative total method would be preferable actually.

I would then need to copy the formula to each cell below, so that it
would in turn likewise. So after the 2 above, the formula would work
on the 6 then 5 then 5 etc. I would simply drag the formula downward.
So assuming the example cells above were in column A, the formula would
reside in column B.

I am not expecting the answer here, (unless it is simple), but I
appreciate any suggestions.

Thank you,

Vincent


--
vincentws
------------------------------------------------------------------------
vincentws's Profile: http://www.excelforum.com/member.php...o&userid=37563
View this thread: http://www.excelforum.com/showthread...hreadid=571944