Learn to filter and copy unique records in an Excel list

Frequently, you need to find and copy the unique records in an Excel data list. For example, you might be preparing to send out a direct mail piece and you want to clean you list first.

Having the unique records copied to another location might help you to spot glaring errors from faulty data entry.

Here are the steps to follow in this video lesson:

Highlight the data that contains the records you wish to filter. This could be the entire data lis or just one column / field.
Select Data, Filter, Advanced Filter. Be sure to select “Copy to another location and to check the “Unique records only” box.
Click the starting cell where you want to place the copied “Unique records” and then click OK.
You may wish to use the AutoFilter to select the data entry errors for correction.