Custom Filter trying to filter for 2 criteria

sderby

I am trying to filter a specific column for two parameters rather than one. The logic string I am trying is :

IF [Functional Area] = "XYZ" OR [Functional Area] = "ABC"

I want to filter the data set down to include just XYZ and ABC but am struggling with writing the logic string.

Preparation

Accepted answers

alexnajm

You don't need the IF part! Just:

[Functional Area] = "XYZ" OR [Functional Area] = "ABC"

All comments

alexnajm

You don't need the IF part! Just:

[Functional Area] = "XYZ" OR [Functional Area] = "ABC"

sderby

Thank you! Easier than I thought 😁 I noticed it worked for me without quotation marks around the Functional area codes... does it matter if they are used or not?

alexnajm

I would leave them!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703