Microsoft Office Tutorials and References
In Depth Information
Playing—or Plying—the Numbers
2. Then just type 75 in the field alongside “is greater than” and click OK.
The records should be filtered as per your instruction (Figure 6–24):
Figure 6–25. Test scores above 75—for exam 2
Note that the Greater Than dialog box we summoned in Figure 6–23 is really the same for all the
Number Filters options, even Custom Filter. As you see, the dialog box allows you enter up to two
filtering conditions of the And or the Or variety, if you wish, and the drop down arrows enable you to
select which kind of mathematical operations you wish to apply. You could have indicated that you
wanted to see all scores for exam 2 which are greater than 75 or less than 60, for example.
And note that you can apply AutoFilters in sequence. Leaving the above results in place (that is, not
restoring all the records), you can then filter another field. Let’s say I now want to apply precisely the
same criterion to test 1—that is, all tests over 75. I can carry out exactly the same Numbers Filters
sequence, yielding (Figure 6–25):
Figure 6–26. Filtering scores above 75 on both exams 2 and 1
We’ve now AutoFiltered both exams 1 and 2, and have learned that Derek, Gordon, John, and Mary
are the only students to have bettered 75 on both. Note in addition the AutoFilter symbol posted in the
AutoFilter handle of fields 1 and 2, indicating that they are the ones that have been filtered. Click Clear in
the Sort & Filter button group, and all the records return.
Note you can also do sorting via the drop-down menu, and also sort and filter by color , as per our
sort discussion. Just keep in mind that if you sort one exam field in Z-A order, for example, the Class
Averages row will also be sorted, even if you’d prefer otherwise. As a result, you may want to go ahead
and delete that row, or insert a blank row between the last actual test score and Class Averages. But we’re
getting back to this issue soon.