Filters: Example of an Advanced Example 2


To show the difference between simple, linear and parenthetical filters, we shall use a list of names that looks like this:

Aaa / Bbb / Ccc / Abc / Bbc

Simple Filter

If you make a filter for which the name is to "Start with A", you get a selection that only includes names starting with the letter A:

Linear criteria

If you set up an advanced filter stating that the name must "Start with A or Start with B", you get a selection for which both criteria can apply:

Parenthetical criteria I

If you set up an advanced filter stating that the name must "Start with A or (Start with B and Contain C)", you get the following selection:

Parenthetical criteria II

We can take the example one step further in a filter stating that the name must "Contain B and (Start with A or (Start with B and Contain C)"


Read more about:

Filters: Example of an Advanced Selection

Advanced Selection