Caveman's Blog

My commitment to learning.

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.

Advertisements

Written by cavemansblog

March 31, 2011 at 7:05 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: