Situation:
Daily I produce a large SS from a database. In one column are names (persons, regions, or empty celss etc.) which may appear multilple 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 end of the column, which will produce a new list of names, having only one (1) occurance of the name, such as;

joe
sue
regionA
Willy Neson

Thanks for any help you can provide