» 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.
|Screenshot // Filtering a Range into a List of Unique Records|