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:
Aaa
Abc
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:
Aaa - (starts with A)
Abc - (starts with A)
Bbb - (starts with B)
Bbc - (starts with B)
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:
Aaa - (starts with A)
Abc - (starts with A)
Bbc - (starts with B and contains C)
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)"
Abc - (contains B and starts with A)
Bbc - (contains B and starts with B and contains C)
Read more about: