(Tech Tip: Excel) How to get unique names from a list

If you have a list of information and you want to remove duplicates, use Excel and follow these simple steps.

1. Open file and click on column A (selects the entire column) 
2. Then choose Data… Sort and select “header row” (see below) and click OK

Now the list is sorted in alpha order 

3. Choose Data… Filter… Advanced Filter

 

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.