Microsoft Office Tutorials and References
In Depth Information
Specifying Advanced Filter Criteria
Clearing an advanced filter
When you apply an advanced filter, Excel hides all rows that don’t meet the criteria you specified.
To clear the advanced filter and display all rows, choose Data
Sort & Filter
Clear.
Specifying Advanced Filter Criteria
The key to using advanced filtering is knowing how to set up the criteria range — which is the
focus of the sections that follow. You have a great deal of flexibility, but some of the options are
not exactly intuitive. Here you’ll find plenty of examples to help you understand how to create a
criteria range that extracts the information you need.
The use of a separate criteria range for advanced filtering originated with the original
version of Lotus 1-2-3, more than 20 years ago. Excel adapted this method, and it has
never been changed, despite the fact that specifying advanced filtering criteria remains
one of the most confusing aspects of Excel. Fortunately, however, Excel’s standard
filtering is sufficient for most needs.
Specifying a single criterion
The examples in this section use a single-selection criterion. In other words, the contents of a
single field determine the record selection.
You also can use standard filtering to perform this type of filtering.
To select only the records that contain a specific value in a specific field, enter the field name in
the first row of the criteria range and the value to match in the second row. Figure 9-19, for
example, shows the criteria range (A1:A2) that selects records containing the value 4 in the
Bedrooms field.
Figure 9-19: The criteria range (A1:A2) selects records that describe homes with four bedrooms.
 
Search JabSto ::




Custom Search