MS-Excel: How to filter out distinct items in a column?
I am not the savviest of Excel users, however I chanced upon this one tip that I would like to share with you. A simple way to filter out distinct items in a column in an Excel file would be to:
1. Highlight the column to be filtered
2. Click on the Data menu; Data –> Filter –> Advanced Filter.
3. Choose the list range and check the “Unique records only”.
Bonus tip: Ctrl + Shift + L is the keyboard shortcut to enable a filter on a column.