Microsoft Excel X for Mac OS X: Visual QuickStart Guide

Advanced Filters

Advanced filters enable you to specify even more criteria than you can with AutoFilters. First set up a criteria range, then use the Advanced Filter dialog to perform the search.

To use advanced filters

1.	Create a criteria range by copying the data labels in the list to a blank area of the worksheet and then entering the criteria in the cells beneath it (Figure 38). Figure 38. Create a criteria range with field names and values that you want to match.
2.	Choose Data > Filter > Advanced Filter (Figure 30).
3.	In the Advanced Filter dialog (Figure 39), select a radio button to specify whether the matches should replace the original ...