One way to extract a "uniques" list is to use Advanced Filter

Assume the names are all in col A, in A2 down
Type a col label in A1 (if required)
Select col A
Click Data Filter Advanced Filter
[Click OK to the Excel prompt to use the first row as labels]

In the Advanced Filter dialog box:
----------------------------------------
Check "Copy to another location"
Ensure that the selected range correctly appears in the "List range:" box
Put for "Copy to:" : B1 (say)
Check "Unique records only"
Click OK

The unique list of names in col A will be extracted in col B
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"news.zen.co.uk" wrote in message
...
I have a long list of names and would like excel to automatically return
just one of each name. For example, a list of 500 names, 10 different
names
appearing 50 times each. How could I get excel just to list those ten
names?