Help: Need to produce list of unique names from multiple name occurances

J

jay

Situation:
Daily I produce a large SS from a database. In one column are name
(persons, regions, or empty celss etc.) which may appear multilpl
times throughout the entire column, such as;

joe
sue
joe
...
...
regionA
joe
sue
Willy Nelson
etc.

Objective:
I need a formula [or macro], which I assume will be placed at the en
of the column, which will produce a new list of names, having only on
(1) occurance of the name, such as;

joe
sue
regionA
Willy Neson

Thanks for any help you can provid
 
J

jay

It's truly amazing the help you get from people like you !

Thank you for your solution. It provided me a quick way to get thi
done. I will attempt to put it in a macro, so that it becomes a
automated task.

j
 
Top