Microsoft Office Tutorials and References
In Depth Information
Filtering Multiple Fields
These are pretty easy, too.
Clicking any of these options will
again unfurl the Custom AutoFilter
dialog box (except the Top 10...
option, which will call up its own
distinct dialog box), as shown in
Figure 7–20.
Figure 7–20. By the numbers: Just type a value and
click OK.
This should be pretty self-evident by now. If you want to see all the
staffers earning more than $30,000, just type 30000 and click OK.
You may also want to take special note of the Top 10… option, which lets you filter the
top (or bottom) 10 values in the field—or the top 20, or the top 5, or any value you
specify (see Figure 7–21).
Figure 7–21. The Top 10... option: Better than a Letterman list
Just click (or type) in the field exhibiting the default 10 and replace it with any other
value, if you want to. And think big: imagine a set of test grades for a lecture class of
200 students, and think how simple would be to determine its top 10 highest scores.
Also, if you click the drop-down arrow by Items field, you’ll call up a Percent option, which
lets you find out the top 10 percent of all scores instead.
Filtering Multiple Fields
In addition, you can filter the filter results. That means, for example, that starting with the
result in which the Sales staff has been filtered, we could then execute a second filter—
say, to find all the Sales personnel who earn more than $35,000. We’d do that by next
clicking the Salary drop-down arrow and filtering for salaries above $35,000—using the
number filters from the previous section. After that double filter is completed, only Ned
Paulson would remain on the screen, because he’s the only salesperson who earns over
$35,000 (see Figure 7–22).
Search JabSto ::

Custom Search