How to get unique names from a list

1. Open file and click on column A (selects the entire column)

 

2. Then choose Data... Sort and select "header row" (figure 1) and click OK

Now the list is sorted in alpha order

3. Choose Data... Filter... Advanced Filter

Fill in as is figure 2:

Select Copy to another location

List Range $A:$A

Criteria Range $A:$A

Copy To $D:$D

Check off 'Unique records only'

 

Press OK

 

4. Done.

When the dialog box goes away, Column D has your unique records.

 

figure 1

figure 2