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

To copy just unique llist of values follow these steps:

Prepare list of data.

data table list

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

click advanced button

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

Advanced Filter


Your unique list is copied.

Unique values copied

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