How To Copy Only Unique Records in Excel

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

To copy just unique list 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.


You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell