Issues with advanced filters

%3CLINGO-SUB%20id%3D%22lingo-sub-1592768%22%20slang%3D%22en-US%22%3EIssues%20with%20advanced%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1592768%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20use%20advanced%20filters%20to%20remove%20certain%20words%20from%20a%20large%20column.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20on%20a%20separate%20tab%20the%20column%20with%20the%20same%20name%20as%20the%20main%20list%20that%20I%20want%20to%20filter%20and%20just%20one%20piece%20of%20text%20to%20filter%20for.%26nbsp%3B%20I%20am%20using%20the%20operator%20like%20this%20%26lt%3B%26gt%3B*iga*%20(IGA%20appears%20in%20the%20middle%20of%20a%20string%20of%20text).%26nbsp%3B%20This%20works%20fine%20but%20when%20I%20add%20a%20second%20operator%20like%20%26lt%3B%26gt%3B*pine*%20and%20extend%20the%20advanced%20filter%20to%20include%20the%20new%20line%20the%20whole%20thing%20breaks%20down%20and%20nothing%20is%20filtered.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECriteria%20tab%20looks%20like%20this%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDescription%3C%2FP%3E%3CP%3E%26lt%3B%26gt%3B*iga*%3C%2FP%3E%3CP%3E%26lt%3B%26gt%3B*pine*%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20I%20said%20if%20I%20just%20search%20for%20iga%20it%20works.%26nbsp%3B%20Extend%20the%20criteria%20to%20include%20another%20(like%20the%20pine%20example%20above)%20and%20the%20whole%20filter%20fails.%26nbsp%3B%20I%20need%20to%20filter%20about%2020%20different%20keyboards%20all%20using%20wildcards.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1592768%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1592929%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20with%20advanced%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1592929%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F400114%22%20target%3D%22_blank%22%3E%40lfk73%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20criteria%20range%20should%20look%20like%20this%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S3476.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212739i16AF9567C0722E0E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22S3476.png%22%20alt%3D%22S3476.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%0A%3CP%3EFor%20conditions%20next%20to%20each%20other%2C%20all%20must%20be%20satisfied%20(condition1%20AND%20condition2).%3C%2FP%3E%0A%3CP%3EFor%20conditions%20below%20each%20other%2C%20at%20least%20one%20must%20be%20satisfied%20(condition1%20AND%2FOR%20condition2)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1594492%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20with%20advanced%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1594492%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3Bare%20you%20serious%3F%26nbsp%3B%20That's%20all%20it%20was%3F%26nbsp%3B%20So%20frustrating%20I%20spent%20like%20an%20hour%20googling%20and%20not%20a%20single%20tutorial%20thought%20to%20mention%20this%20simple%20thing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

2 Replies

@lfk73 

The criteria range should look like this:

 

S3476.png

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)

@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.