Hi I'm trying to use the advance filter for multiple criteria in one column. It works fine if the criteria is ="*10*" (ie where the cell in the range has 10 in the string) plus other = criteria
What I cannot get to work is where the range doesn't equal 10 in the string.
I've tried ="<>*10*" and other variations to no joy.
Is this possible?