Unique items in the list

Excel 365 2013 2010 2007 2003
To get unique items from 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 2016

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

Advanced button of Sort and Filter in Excel 2016

In the Advanced Filter dialog box:

Advanced Filter Excel 2016
  • In the Action group, choose the Copy to another location.
  • In the List range field, choose a range (E.g., $A$1:$A$12).
  • In the Copy to field, choose a new location (E.g., $C$1:$C$12).
  • Select the Unique records only option.

See also this tip in French: Comment utiliser les éléments uniques de la liste.

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