Returning a list of unique items in a range by using a filter
For example, if you have a range:
On the Data tab, in the Sort & Filter group, choose Advanced button:
In the Advanced Filter dialog box:
- 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).
- Click the Unique records only.
Permission is granted for article quotations from OfficeToolTips, provided the direct link to the source articlehttp://www.officetooltips.com/excel 2016/tips/returning a list of unique items in a range by using a filter.html