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/satuperail/home/example/LibreOfficeExample.ods?attredirects=0&d=1
Thanks!!!