# What is the symbol (or command) for "Does Not Contain" in Advanced Filtering? [closed]

I probably did not ask the question correctly, but this is my dilemma. I have a macro that generates "Advanced Filtering" commands. The <>, <=, >= symbols work great. BUT, suppose I wish to filter out all instances of "Chet Atkins" from my music database. When I use the <>Chet Atkins option, the advanced filter removes "Chet Atkins", but "Chet Atkins & Jerry Reed" (etc) remains. My question is how do I remove all instances of "Chet Atkins" without adding "<> Chet Atkins & Jerry Reed" (and all other instances of "Chet Atkins") to the advanced filter? Is there a symbol for "Does Not Contain"?

This link show my current Advanced Filtering setup => https://sites.google.com/site/satuper...

Thanks!!!!

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2016-02-28 20:22:28.598275

Sort by » oldest newest most voted

Find the option "Search criteria = and <> must apply to whole cells" in Tools > Options > Calc > Calculate. If it is not checked, then =Chet Atkins will find records too, where the text "Chet Atkins" is only part of the cell content, and <>Chet Atkins will find the complement of them.

Or you enable the option "Regular expressions" in the filter definition and search for ^(?!.*Chet Atkins).*\$. (?!.*Chet Atkins).* seems to work too. Look for technical term "negative look-ahead".

But I don't know, how to set these options using a macro.

more