Preparation - Custom Filters (A AND B) OR (C AND D)

Question

Description of Process

In the custom filter tool, I want to write an expression that says something along the line of

(Column 2=48040 AND Column 1 Contains QZ)

OR

(Column 2=50786 AND Column 1 Contains QZ)

OR

(Column 2=51939 AND Column 1 Contains QZ

Can this be done with one expression or do I need to make two filters?

Can you help me with a sample workflow for this?

Description of Input

Two Columns

Description of Output (DESIRED OUTPUT)

see above

Input Sample File.xlsx

Amilley · Answer

@Leanna12  You could absolutely use your logic in a very simple compound statement:

To that point @Luke_C's solution would work as well, but may be less readable for those not familiar with the 'value IN' function - on the plus side, its more tight, and if you needed to add another condition, you could just expand the list in the IN clause - so there is some continuity there!

Hope that helps!

Luke_C · Answer

Hi @Leanna12

You could try this filter configuration, using the 'In' operator

[Column 2] in(48040,50786,51939) and contains([Column 1],'QZ')