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

or is identical, or the number is larger than or equal to the one you enter in the associated combo box.
✦ Is Less Than: Matches records where the entry in the field comes before the text in the alphabet, comes before the date, or is less than the number you enter in the associated combo box.
✦ Is Less Than or Equal To: Matches records where the entry in the field comes before the text in the alphabet or is identical, the date comes before or is identical, or the number is less than or equal to the one you enter in the associated combo box.
✦ Begins With: Matches records where the entry in the field starts with the text, the part of the date, or the number you enter in the associated combo box.
✦ Does Not Begin With: Matches records where the entry in the field starts with anything other than the text, the part of the date, or the number you enter in the associated combo box.
✦ Ends With: Matches records where the entry in the field ends with the text, the part of the date, or the number you enter in the associated combo box.
✦ Does Not End With: Matches records where the entry in the field ends with anything other than the text, the part of the date, or the number you enter in the associated combo box.
✦ Contains: Matches records where the entry in the field contains the text, the part of the date, or the number you enter in the associated combo box.
✦ Does Not Contain: Matches records where the entry in the field contains anything other than the text, the part of the date, or the number you enter in the associated combo box.
Note that you can use the Begins With, Ends With, and Contains operators and their negative counterparts when filtering a text field — you can also use the question mark (?) and asterisk (*) wildcard characters when entering the values for use with these operators. (The question mark wildcard stands for individual characters, and the asterisk stands for one or more characters.) You use the other logical operators when dealing with numeric and date fields.
When specifying the values to evaluate in the associated combo boxes on the right side of the Custom AutoFilter dialog box, you can type in the text, number, or date, or you can select an existing field entry by clicking the box’s drop-down list button and then clicking the entry on the drop-down menu. In date fields, you can select the dates directly from the date drop- down palette opened by clicking the box’s Date Picker button (the one with the calendar icon).
Figure 2-3 illustrates setting up filtering criteria in the Custom AutoFilter dialog box that selects records whose Salary values fall within two separate ranges of values. In this example, I’m using an OR condition to filter out all
Filtering Data 611
Book VI Chapter 2
Filtering and Querying a Data List