Filter & Comma Deliminated Question

I'm trying to find a simpler formula to use in a filter. For example, I've got a file containing every state across the US, If I want to filter specific states instead of writing out [State] = "CO or [State] = 'TX', etc.. for each state individually, can I do something like [State} within (DE,IL,KS,MA,MD,ME,MI,MN,NH,NJ,NY,OH,PA,RI,UT,VA,VT,WI)? Basically I don't want to have to write out each state individually.

Workflow

Common Use Cases

Help

Accepted answers

CarliE

Hi @dbdirks,

You can do [State] in ("DE","IL","KS","........) -- Each value needs to be wrapped in quotes since its a string.

If this solved your problem, please mark as a solution to help other members on the community.

Thanks,

All comments

mceleavey

@dbdirks ,

It sounds like there's a much easier way of doing this.

Can you post some mock data so we can see the format and what you're trying to do?

CarliE

Hi @dbdirks,

You can do [State] in ("DE","IL","KS","........) -- Each value needs to be wrapped in quotes since its a string.

If this solved your problem, please mark as a solution to help other members on the community.

Thanks,

dbdirks

Thanks Carli! I knew I was close but forgot about the quotes. This worked.

AncientPandaman

i know it solved, but when come to this amount of criteria. (>10)

it better to put in an excel/ text tool, then join tool to filter. it easier to check and change in future.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703