Microsoft Office Tutorials and References
In Depth Information
Filtering Data
Choosing Text Comparison
Filters
Text comparison is when you specify a range such
as “begins with” or “does not equal.” Other options
might be “exactly” or “contains.” Following are the
different options:
Click the filter arrow for the text column by which
you want to filter data and choose Text Filters.
From the following submenu of comparison filters,
make a selection. The Custom AutoFilter dialog
box you see in Figure 11-34 appears. The
comparison filter you selected appears in the Line
description box, but you can click the drop-down menu
and select a different comparison function. In the
first list box on the right, type the data you want to
filter and then click the OK button
Equals or Does Not Equal: Equals locates
all records in which the selected field cells
exactly match or don’t match the text you
specify. For example, if you look for records
matching “Chicago,” only the records with
Chicago appear. Records containing East
Chicago, Chicago Hill, Las Vegas, Chicagoan,
Seattle, or Boston do not appear. If you
chose Does Not Equal you might see East
Chicago, Chicago Hill, Las Vegas, Chicagoan,
Seattle, or Boston, but not Chicago.
Begins With or Ends With: Locates all
records in which the selected field cells
begin or end with the text you specify. If
you chose Begins With, you’ll see Chicago,
Chicago Hill, and Chicagoan, but not East
Chicago, Las Vegas, Seattle, or Boston. If you
chose Ends with, you would see the records
for Chicago and East Chicago, but not
Chicago Hill, Las Vegas, Chicagoan, Seattle,
or Boston.
Figure 11-34
The Custom AutoFilter dialog box.
Choosing Additional
Comparison Criteria
When you want your data to meet more than one
criterion, Excel can support that as well. For
example, you want to locate your clients in Cleveland OR
Cincinnati. The OR means that either criterion fits
what you want. Another example would be if you
want to view only the customers in California whose
sales are more than a specified amount. In that
situation you would use the AND filter. The AND filter
specifies that both criteria must be met. Take a look
at the steps for multiple comparison criteria:
Contains or Does Not Contain: Locates all
records in which the selected field text
contains or doesn’t contain the text you specify.
The text could be at the beginning, middle,
or end of the field cell value.
Search JabSto ::




Custom Search