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

610 Filtering Data
Figure 2-3:
Using Custom AutoFilter to filter out records except for those within a range of salaries.
Here, you select the type of operator to use in evaluating the first and second conditions in the top and bottom drop-down list boxes and the values to be evaluated in the first and second conditions in the associated combo boxes. You also specify the type of relationship between the two conditions with the And or Or option button. (The And option button is selected by default.)
When selecting the operator for the first and second condition in the leftmost drop-down list boxes at the top and bottom of the Custom AutoFilter dialog box, you have the following choices, depending on the types of entries in the selected field:
✦ Equals: Matches records where the entry in the field is identical to the text, date, or number you enter in the associated combo box.
✦ Does Not Equal: Matches records where the entry in the field is any- thing other than the text, date, or number you enter in the associated combo box.
✦ Is After: Matches records where the entry in the date field comes after the date you enter or select in the associated combo box.
✦ Is After or Equal To: Matches records where the entry in the date field comes after or is the same as the date you enter or select in the associ- ated combo box.
✦ Is Before: Matches records where the entry in the date field precedes the date you enter or select in the associated combo box.
✦ Is Before or Equal To: Matches records where the entry in the date field precedes or is the same as the date you enter or select in the associated combo box.
✦ Is Greater Than: Matches records where the entry in the field follows the text in the alphabet, comes after the date, or is larger than the number you enter in the associated combo box.
✦ Is Greater Than or Equal To: Matches records where the entry in the field follows the text in the alphabet or is identical, the date comes after