Without adding another column of "helper data", you'll need to use a pretty
hefty array formula for a simple task. As long as the data set isn't huge,
this should work.

With numbers in column A, names in Column B, enter this formula in ROW1
somewhere. It needs to be row1, like C1, or D1, or H1....

=IF(ROW()COUNTIF($A$1:$A$7,4),"",INDEX($B$1:$B$7,
SMALL(IF($A$1:$A$7=4,ROW($A$1:$A$7),999),ROW())))

....and press CTRL-SHIFT-ENTER to confirm the formula array. Just pressing
ENTER will break the array and you will only get the first answer. So,
CTRL-SHIFT-ENTER and braces { } will appear around your formula.

Now copy that cell down and the names will appear.

You can expand it, but expand all the ranges equally.
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Abnerz" wrote:

I meant to say, based on column 1, I want to list the UNIQUE names in column 2

--
Abner


"Abnerz" wrote:

Hi, hope you can help.
Column 1 Column 2
4 Al
5 John
5 Pete
4 Rob
5 Al
4 Paul
5 Rob

Answer to above:
For 4:
Al
Rob
Paul



Based on colmn E, I want to list the UNIQUE names in column 2







--
Abner