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:
- 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: