Unique items in the list
Excel
2016
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 Data in Excel 2016](/images/tips/122_2016/1.png)
On the Data tab, in the Sort & Filter group, choose the Advanced button:
![Advanced buttin of Sort and Filter in Excel 2016 Advanced button of Sort and Filter in Excel 2016](/images/tips/excel_button2016/advanced.png)
In the Advanced Filter dialog box:
![Advanced Filter Excel 2016 Advanced Filter Excel 2016](/images/tips/122_2016/3.png)
- 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.
![Data Data](/images/tips/122_2016/4.png)
See also this tip in French: Comment utiliser les éléments uniques de la liste.