| |
Custom
AutoFilter
What if
you wanted to see all records where the region was either
West or Central? Or what if you wanted to see all records
for sales between $25,000 and $30,000? The filters as they
stand now would be unable to do this. However, you can create
a Custom AutoFilter to meet your needs.
You can
set up two different criteria, separated either by an AND
or an OR. If AND, both criteria must be met. Either criteria
is enough for an OR criteria. In this example, we'll set up
a criteria to choose sales between $25,000 and $30,000.
Here is
the result.
|
