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