Microsoft Office Tutorials and References
In Depth Information
Filtering Data Lists
Using custom filters
In addition to filtering a data list to records that contain a particular field
entry (such as Newark as the City or CA as the State), you can create custom
AutoFilters that enable you to filter the list to records that meet less-exacting
criteria (such as last names starting with the letter M) or ranges of values
(such as salaries between $25,000 and $75,000 a year).
To create a custom filter for a field, you click the field’s AutoFilter button and
then highlight Text Filters, Number Filters, or Date Filters (depending on the
type of field) on the drop-down list and then click the Custom Filter option at
the bottom of the continuation list. When you select the Custom Filter option,
Excel displays a Custom AutoFilter dialog box, similar to the one shown in
Figure 11-8.
You can also open the Custom AutoFilter dialog box by clicking the initial
operator (Equals, Does Not Equal, Greater Than, and so on) on the field’s Text
Filters, Number Filters, or Date Filters submenus.
Figure 11-8:
Use a
custom
AutoFilter
to display
records
with entries
in the
Salary field
between
$25,000 and
$75,000.
In this dialog box, you select the operator that you want to use in the first
drop-down list box. (See Table 11-2 for operator names and what they
locate.) Then enter the value (text or numbers) that should be met, exceeded,
fallen below, or not found in the records of the database in the text box to
the right.
Search JabSto ::




Custom Search