Work smarter, not harder! Excel tip – filter records for unique values and copy to a different worksheet. Use this tip when you have a list of records containing duplicates and want to copy the unique records to another worksheet in the same or a different workbook.

Filter Records for Unique Values and Copy to a Different Worksheet

Scenario: Our source data is a list of items that contains duplicates. From this list, we want to copy only the unique values to another worksheet. To do this: 

1. From the destination worksheet, on the “Data” tab, in the “Sort & Filter” group, click the Advanced button. The “Advanced Filter” dialog box appears.
2. Enable “Copy to another location.”
3. Click in the “List range” box, navigate to the worksheet containing the source data, and select the list.
4. Click in the “Copy to” box, and specify where the list of unique values will be copied.
5. Enable “Unique records only.”
6. Choose OK. The unique values from the source data are copied to the destination worksheet.

Watch the video below and see how to filter records for unique values and copy to a different worksheet.

If you need help or information about the tip, contact us and we’ll be happy to go over it with you.