Filtering with large amount of conditions

Hey,

I have a list of conditions in excel, more than 100 unique numbers, that I would like to use as conditions in filter, separation with "OR".

Manually its very slow to start putting these into the custom filter one by one. Any quick tips on how to automate this filtering?

Preparation

Accepted answers

binu_acs

@coderman One option I am thinking put all these unique numbers in a text input tool and connect this and the input file with the join tool. Then take the records from the L anchor of the join tool

All comments

binu_acs

@coderman One option I am thinking put all these unique numbers in a text input tool and connect this and the input file with the join tool. Then take the records from the L anchor of the join tool

IraWatt

Hey @coderman,

Can you give some example input data, your excel unique number format with your expected result. Just to give an idea of how to approach this?

Thanks,

Ira

coderman

yeah so I have excel where I have
1
2
3

4...

and I want to use all these as a condition for a given column to find these lines.

IraWatt

Without a full example I am still a little confused but It sounds like @binu_acs's solution is the way to go.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703