Page 630 - Excel 2013 All-in-One For Dummies

612 Filtering Data
records where the salaries fall below $35,000 or are greater than $75,000 by entering the following complex condition:
Salary Is Greater Than 75000 OR Is Less Than 35000
Using the Advanced Filter
When you use advanced filtering, you don’t use the field’s AutoFilter buttons and associated drop-down menu options. Instead, you create a so-called Criteria Range somewhere on the worksheet containing the data list to be filtered before opening the Advanced Filter dialog box.
If you use the Advanced Filter feature to do a query, you extract copies of the records that match your criteria by creating a subset of the data list. You can locate the Criteria Range in the top rows of columns to the right of the data list and then specify the Copy To range underneath the Criteria Range, similar to the arrangement shown in Figure 2-4.
To create a Criteria Range, you copy the names of the fields in the data list to a new part of the worksheet and then enter the values (text, numbers, or formulas) that are to be used as the criteria in filtering the list in rows under- neath. When setting up the criteria for filtering the data list, you can create either comparison criteria or calculated criteria.
Figure 2-4:
Using Advanced Filter
to copy records that meet the criteria in the Criteria Range.