How to filter Multiple data

Question

Hi Team,

I have a input file with columns namely A & B. Column A contains row values as 21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43.

My desired output is, I want row values from column A along with column B which has only 26,38,42.

I have attached the sample input & desired output.

Please help me on this.

Sample Input & desired Output.xlsx

atcodedog05 · Accepted Answer

Hi @Gsiva3

You can use the filter tool like below.

Workflow:

Hope this helps : )

messi007 · Accepted Answer

@Gsiva3,

Please see below :

Attached the workflow,

Regards