Tip Printed from ExcelTip.com

---

Filtering a Range into a List of Unique Records


To filter a range into a List of unique records:

1. Select a cell the range (see screenshot).
2. From the Data menu, select Filter, and then Advanced Filter.
3. Select Copy to another location.
4. In the Copy to box, insert a cell address.
5. Select the Unique records only checkbox, and then click OK.