Chapter 2 Working with Data 59
To remove the fi lters:
1 Click the Other drop-down fi lter arrow and click Clear Filter from
“Other”.
The second fi lter is removed, and now only the results of the fi rst
fi lter are displayed.
2 Click the Sort & Filter button from the Editing group on the Home
tab and then click Filter from the drop-down menu.
Excel stops running AutoFilter altogether and removes the fi lter drop-
down arrows from the worksheet.
Using the Advanced Filter
There might be situations where you want to use more complicated criteria
to fi lter your data. Such situations include criteria that
Require several And/Or conditions
Involve formulas and functions
Such cases are often beyond the capability of Excel’s AutoFilter, but you
can still do them using the Advanced Filter. To use the Advanced Filter,
you must first enter your selection criteria into cells on the worksheet.
Once those criteria are entered, you can use them in the Advanced Filter
command.
Try this technique by recreating the pair of criteria you just entered; only
now you’ll use Excel’s Advanced Filter.
To create a query for use with the Advanced Filter:
1 Click cell B15, type Advanced Filter Criteria, and press Enter.
2 Type Gas in cell B16 and press Ta b. Type Other in cell C16 and
press Enter.
3 Type < 8500 in cell B17 and press Ta b. Type < 5 7500 in cell C17
and press Enter.
If two criteria occupy the same row in the worksheet, Excel assumes that
an And condition exists between them. In the example you just typed in,
both criteria were entered into row 17, and Excel assumed that you wanted
•
•
