Extract unique records:

You can use an Excel Advanced Filter to extract a list of unique items in the database. For example, get a list of customers from an order list, or compile a list of products sold:
Note: The list must contain a heading, or the first item may be duplicated in the results.
1. Select a cell in the database.
2. From the Data menu, choose Filter, Advanced Filter.(In Excel 2007, click the Data tab on the Ribbon, then click Advanced Filter.)
3. Choose 'Copy to another location'.
4. For the List range, select the column(s) from which you want to extract the unique values.
5. Leave the Criteria Range blank.
6. Select a starting cell for the Copy to location.
7. Add a check mark to the Unique records only box.
8. Click OK.