Returning one text value in a long list?

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?

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" <steven.lancaster@phresearch.com> wrote in message
news:43689607$0$23291$db0fefd9@news.zen.co.uk...
> 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?
>
>