How to Filter an Excel Database
by docnmail.com - Free Online Courses for Everyone

Free Excel Course

• Introduction

• Data Form

• AutoFilter

• Uniques, Blanks...

• Display Top 10

• Custom Filters

• Match Selection

Advanced Filters

• Set up Worksheet

• Perform Filters

• Use Extract Range

More Free Courses:

Computer Courses

Excel Courses

Database Courses

All Topics

MS Excel books:
from Amazon.com

Excel 2003 Formulas

Microsoft is either a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries.

 

Page 4 of 10

AutoFilter - Unique entries, Blanks & Non-Blanks

Choose a unique entry from one of the drop boxes.

For example, if you're using the Black Hills database click Harney Peak Trail System from the drop box in column A.  Instantly all records not meeting the criteria are hidden, leaving only the 11 trails at Harney Peak.  Notice that the drop box arrow in that column is now blue, indicating that the list has been filtered on that column.  To redisplay all the records click the blue arrow and click all.

A group of records that has been filtered on a certain column, can be further filtered on another column.  As it was done in the example above - once again filter out the Harney Peak Trails.  Choose a unique entry from another of the drop boxes - perhaps Difficult in the Difficulty column.  The list is further narrowed to include only the records that meet the criteria specified for both columns, and the arrow for each column is blue.  The complete database may be redisplayed by clicking each blue arrow and selecting all or by hovering Filter on the Data menu and selecting Show All.

Displaying Blanks and Non-Blanks

Simply click Blanks to display the records where there is a blank cell in that column.  Vise Versa for Non-Blanks.

Redisplay the whole database.  Data>Filter>Show All

To turn AutoFilter off and remove the arrows in the Heading cells Click Data, hover Filter and uncheck AutoFilter by clicking it.

Next Page - Displaying the Top 10 >>

Site Map  •  FAQs  •  Link to Us  •  Educational Gift Ideas  •  Add a Course  •  Contact Us

© 2008 Learning Link Finders, Inc. - All Rights Reserved - Modified on 01/01/08

All trademarks and registered trademarks appearing on the Docnmail.com website are the property of their respective owners.
By providing links to other sites, Learning Link Finders, Inc. does not guarantee, approve or endorse the information or products available
at these sites, nor does a link indicate any association with or endorsement by the linked site to Docnmail.com.