I am trying to use the Advanced Filter on a report to remove our internal responses, but keep our customer responses. All internal responses use email addresses that end in@fred .com.au or@fred .com – to do this I have set the Advanced filter up as follows:
Any help appreciated?
You just need to change the OR between your tests to an AND.
Right now the response is included if it does not match the first pattern or it does not match the second pattern. only a response the matches both would be suppressed.
Changing to an AND, a response is included if it does not match either pattern.
Logic with negatives (e.g. does not contain) can often be confusing.
Thanks for this – good to know for future.
In this instance I ended up getting around it by using 2x Question Answer (email) does not contain options instead.