Hi

i would like to look up a range of names and return a complete listing of those name in another column without duplication.

Eg
Col A has
A1
A2
A1
A4
A5
A4
A3
A6
A5

and i would like to have a complete list
A1
A2
A3
A4
A5
A6

So that i know what is and is not in at first listing.

Any idea which function is to use?

Thanks