Auto Filter Criteria

To enable custom filtering, first select a variable (click on the variable head) in a spreadsheet. Then:

Ribbon bar. Select the Data tab. In the Transformations group, click Auto Filter. On the menu, select Auto Filter.

Classic menus. On the Data - Auto Filter submenu, select Auto Filter.

At the right side of the variable header, a small button will be displayed. Click this button, and from the menu, select (Custom...) to display the Auto Filter Criteria dialog box. Use these options to specify, via case selections, which cases you want to include in the custom auto filter criteria.

See also, the Auto Filter Criteria menu topic for more details.

Enable Auto Filter Criteria. Select the Enable Auto Filter Criteria check box to activate and/or create custom auto filter criteria.

Include cases. Use the options in the Include cases group box to specify which cases to include in the custom auto filter criteria.

All. Select the All option button to include all cases in the custom auto filter criteria.

Specific, selected by. Select the Specific, selected by option button to include cases in the custom auto filter criteria that satisfy the conditions in the Expression or the or case number boxes. Note that it is possible to enter conditions in both the Expression and the or case number boxes.

Expression. Use the Expression box to enter new or edit existing case selection condition expressions. Refer to the Case Selection Conditions Syntax Summary for information on how to properly specify these expressions.

or case number. Use the or case number box to include a specific subset of cases in your custom auto filter criteria. You can enter case numbers and/or a range of case numbers separated by commas.

Exclude cases (from the set of cases defined in the 'Include cases' section). Use the options in the Exclude cases group box to exclude cases from the custom auto filter criteria that satisfy the conditions in the By expression or the or case number boxes.

By expression. Use the By expression box to enter new or edit existing case selection condition expressions. Refer to the Case Selection Conditions Syntax Summary for information on how to properly specify these expressions.

or case number. Use the or case number box to ensure that the custom auto filter criteria are not applied to a specific subset of cases. You can enter case numbers and/or a range of case numbers separated by commas.

Review Variables. Click the Review Variables button to display the Variables dialog box, from which you can view the variables in the spreadsheet.

Clear All. Click the Clear All button to clear all boxes in the Auto Filter Criteria dialog box.

Open. Click the Open button to display the standard open file dialog box, which is used to open a previously saved custom auto filter criteria (or case selection condition file).

Save As. Click the Save As button to display the standard save file dialog box, which is used to save custom auto filter criteria in a file. Custom auto filter criteria can later be opened using the Open button.

OK. Click the OK button to set your custom auto filter criteria and close this dialog box.

Cancel. Click the Cancel button to close this dialog box. Any changes made to the custom auto filter will be disregarded.