How to copy only unique records?

In this Excel tutorial you will teach yourself how to copy only unique records.

To copy just distinct list of values follow these steps.

Data set

Prepare list of data.

copy only unique records data table list

Go to the ribbon to the Data tab. Click Advanced button.

click advanced button

Filter to apply

Advanced filter window pops up. Fill fields in:

  • tick Copy to another location
  • List range is your data table. $A$1:$A$14 here
  • Criteria range are criteria you like. It depends what you want to copy
  • Copy to is the cell where you want to paste a header of your table
  • tick Unique records only

copy only unique records Advanced Filter


Your unique list is copied.

Unique values copied

This is a good way to copy only distinct values from your list. Excel will do it with just several your clicks.