If you're not one for typing out filter terms yourself you can make use of the Advanced Filter tool, this is also a good way to learn or check syntax. To open the Advanced Filter tool click on the little down arrow to the right of the filter search field.

     

    The Advanced Filter tool allows you to chain filters together graphically, here's an example.

    You can see that by adding filters in the Advanced Filter tool that it fills the filter search field with the specified filter terms, you can edit them there or in the tool itself. Note that altering the filter search field will clear the Advanced Filter tool, future version will allow edits in the text field to be applied to the tool.

    • No labels