Aug 17 2020 05:14 AM
I'm trying to use advanced filters to remove certain words from a large column.
I have on a separate tab the column with the same name as the main list that I want to filter and just one piece of text to filter for. I am using the operator like this <>*iga* (IGA appears in the middle of a string of text). This works fine but when I add a second operator like <>*pine* and extend the advanced filter to include the new line the whole thing breaks down and nothing is filtered.
Criteria tab looks like this;
Description
<>*iga*
<>*pine*
As I said if I just search for iga it works. Extend the criteria to include another (like the pine example above) and the whole filter fails. I need to filter about 20 different keyboards all using wildcards.
Please help.
Aug 17 2020 06:26 AM
The criteria range should look like this:
For conditions next to each other, all must be satisfied (condition1 AND condition2).
For conditions below each other, at least one must be satisfied (condition1 AND/OR condition2)
Aug 17 2020 03:04 PM
@Hans Vogelaar are you serious? That's all it was? So frustrating I spent like an hour googling and not a single tutorial thought to mention this simple thing.
Thanks.