Do you ever want to extract a list of unique records from a massive list like the one in column A below which has over 900 records?
It would be tiresome to copy and paste the list and then delete the duplicate lines.
Of course we could use the Remove Duplicates tool on the Data tab of the ribbon, but we’re going to try something different today.
And that is to use Excel’s Advanced Filter to extract a list of unique records.
Excel Advanced Filter
It’s dead easy. Simply select the cells containing the list you want to filter >
- On the Data tab of the ribbon select Advanced Filter
- Select ‘Copy to another location’, check your ‘List range’ is correct, enter the cell you want your list copied to, then check the ‘Unique records only’ check box.
Voila. You now have a list of unique records.
The only real limitation is that you can only copy filtered data to the active sheet. No big deal. Just copy the complete list to the sheet you want before you use the Advanced Filter.
If you liked this please click the Facebook button below and share it with your friends 🙂