Trying to use filter tool to pull in specific criteria for multiple columns for true/false

[dberroth]

Hello, I have two columns, shown below as test data. The formula I'm trying to write in the filter tool is the IF statement below, I'm using Left([Column1],1) = "A" to determine if Column1 begins with A, but having a hard time incorporating the additional "filter critera" determining if Column2 = CA or US, any ideas appreciated?

IF: Column1 begins with ‘A’ AND Column2 = US or CA – EXCLUDE

COLUMN1                COLUMN2

A343434334              MX

AR4656544                US

445654656                 CA

4545345345                US

[AbhilashR · Accepted solution]

Hi @dberroth, can you give this logic a try?

Left([Field1],1) != 'A'
  AND
([Field2] != 'US'
OR [Field2] != 'CA')

[jdunkerley79 · Accepted solution]

I would suggest using:

StartsWith([COLUMN1], "A")
AND
[COLUMN2] NOT IN ('US', 'CA')

Sample attached

[grazitti_sapna · Accepted solution]

Hi @dberroth,

Is this what you are looking for?

[dberroth]

Thank you all, you all had great options