Unique items in the list

Excel 365 2016 2013 2010 2003
In order to get unique items in a range you can use the Advanced Filter to extract the unique values from a column of data and paste them to a new location.

For example, if you have a range:

Data in Excel 2007

On the Data tab, in the Sort & Filter group, choose Advanced button:

Sort and Filter Excel 2007

In the Advanced Filter dialog box:

Advanced Filter Excel 2007
  • In the Action group choose the Copy to another location.
  • In the List range field choose a range (E.g. Sheet1!$A$1:$A$12).
  • In the Copy to field choose a new location (E.g. Sheet1!$C$1:$C$12).
  • Click the Unique records only.
Data in Excel 2007

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.