Excel > Excel 2003 Intermediate > Sorting and Filtering

Custom AutoFilter

Custom AutoFilter enables you to use your own criteria to filter your data. For example, the orders after a specific date, or the orders less than a specific order total.

Apply a custom filter

1. Select a cell in the range that you wish to filter
2. Click Data & Filter and then AutoFilter from the submenu that appears
3. Click the filter button for the column you want to filter



4. From the filter list, select Custom



5. Select the required operator from the first list box
6. In the list box next to the operator, select a value from the list or enter your own value



7. If required, select either And or Or and apply a second criteria to filter by

Note that Custom Filter accepts the use of the wildcard characters * and ?. ? represents a single character and * represents a series of characters such as *west to filter Southwest, Northwest and West.

8. Click Ok

The filter is applied to the data list.

Autofilter Date formatting

Guides