To create a custom AutoFilter, select a field heading that you want to filter with, and choose Custom from the AutoFilter drop menu.

 

 1                                                 2

This is an image of the Custom AutoFilter dialogue box.

 

You can use the drop down arrows and radio buttons to set up filtering criteria for your records.

 

 

The first drop list (number 1), with the default value Equals, will display the following expressions that you can choose from to create a filter.

·              Equals

·              Does not equal

·              Is greater than

·              Is greater than or equal to

·              Is less than

·              Is less than or equal to

·              Begins with

·              Does not begin with

·              Ends with

·              Does not end with

·              Contains

·              Does not contain

 

The next drop list (number 2 in the image) will contain values from your data list belonging to the current field.

You can select the And radio button or the Or radio button, to incorporate additional criteria into your filter.

The remaining drop lists are the same as the first two. You can use the radio buttons to combine filtering conditions, or just filter base on options from the first two drop lists. To understand how to create a custom filter with these option lists, look at the following example.

Selections have been made in this custom filter box that essentially state, Weight is greater than 145 and is less then 180. Both of these conditions must be met for a record to be shown. This Filter will remove all records with a weight less than or equal to 145 and greater or equal to 180.

Here are the records that this filter selected. Note the blue colored arrow next to the weight heading. This indicates that the weight field is used for filtering in this case.

When you use the And/Or radio buttons to build custom filters, remember:

 If you have condition A and condition B, both conditions (A and B) must be satisfied for the record to be shown.

If you have condition A or condition B; records that satisfy either condition will be shown.