Microsoft Office Tutorials and References
In Depth Information
To Enter Custom Criteria Using AutoFilter
3
Click the OK
button in the
Custom AutoFilter
dialog box to display
records in the table
that represent sales
reps whose ages
are between 30
and 40 inclusive
(Figure 5–56).
Filter
button
fi lter icon
indicates Age
fi eld used to
fi lter records
4
After viewing the
records that meet
the custom cri-
teria, click the
Filter button
on the Ribbon.
I
records
representing
sales reps whose
ages are greater
than or equal to
30 AND less than
or equal to 40
Experiment
Create fi lters on
other fi elds in
the table, such as
Gender and State.
When you are
fi nished, click the
Filter button and
then repeat the
steps above so that
the worksheet
appears as it does in
Figure 5–56.
Figure 5–56
How are the And and Or option buttons used?
You can click the And option button or the Or option button to select the AND or the OR operator. The AND operator
indicates that both parts of the criteria must be true; the OR operator indicates that only one of the two must be true.
Use the AND operator when the custom criteria is continuous over a range of values, such as (30 ≤ Age ≤ 40). Use the OR
operator when the custom criteria is not continuous, such as Age less than or equal to 30 OR greater than or equal to 40
(30 ≤ Age ≥ 40).
 
 
Search JabSto ::




Custom Search