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

To set up the criteria by which records are selected in the Filter Data dialog box (similar to the one shown in Figure 2-19), click the field for which you want to set criteria and then select the criteria to use from the drop-down list box on the left and the value to be evaluated in the combo box on the right.
External Data Query 637
Figure 2-19:
Specifying how the data are to be filtered in the new external database query.
The criteria available in the drop-down list boxes on the left are the same as those used with the Custom AutoFilter (see the “Custom AutoFilter at your service” section earlier in this chapter for details) with the exception of the “like” and “not like” and “is Null” and “is Not Null” operators, which are not available when setting criteria for the Custom AutoFilter. (The “like” operator refers to entries that sound like one that you enter in the associated combo box on the right, and “Null” refers to empty entries in the field.)
When entering the values to be evaluated in the associated combo boxes on the right side of the Filter Data dialog box, you can use the question mark (?) and asterisk (*) wildcard characters (question marks for single characters and the asterisk for multiple characters) in the text that you enter in these boxes. You can also select data entries in a field from which to compare to by selecting them from the drop-down list.
To set up an AND condition, make sure that the AND option button is selected when you specify the second and even third set of filtering cri- teria. (Remember that, in an AND condition, records are selected only when all sets of criteria are TRUE.) To set up a logical OR condition, click the Or option button before you specify the second or even third set of criteria. (Remember that, in an OR condition, records are selected when any one of the sets of criteria are TRUE.)
Note that if you want to acquire all data in a selected field, you don’t specify any filtering criteria for that field in the Filter Data dialog box.
Book VI Chapter 2
Filtering and Querying a Data List