Caveman's Blog

My commitment to learning.

Posts Tagged ‘Excel

MS-Excel: How to filter out distinct items in a column?

leave a comment »


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.

Written by cavemansblog

March 31, 2011 at 7:05 am