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. Date filter

  5. From the filter list, select Custom
  6. Custom date filter

  7. Select the required operator from the first list box
  8. In the list box next to the operator, select a value from the list or enter your own value
  9. Applying greater than filter

  10. If required, select either And or Or and apply a second criteria to filter by
  11. 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.

  12. Click Ok

The filter is applied to the data list.

Follow us on

Facebook  Twitter  You Tube