Help with beginner question for filtering

Need help with possible dynamic formula to filter. Previous user had macro saved to desktop. I want to be able to filter based on results in input 2. I need a "tab" using label for each result from Input 2. So, my result output would be three tabs labeled "A", "D", "F". I have attached excel example as well. Do I have to use dynamic filter or is there another way? Thank you

Info Request 2.xlsx

Workflow

Datasets

Output

Common Use Cases

Preparation

Accepted answers

jrlindem

@HOUEW I've attached a file that has two workflows. Left side shows how to do this if your data comes in vertically. The right side shows it coming in horizontally. If you can adapt your upstream components; the concept shows how you can get there in either scenario.

Hope that helps, -Jay

20251020_jrlindem_example.yxmd

binu_acs

@HOUEW Dynamic way of doing this with the help of a bath macro

DynamicFilter_20102025.yxzp

All comments

jrlindem

I would list out the values in INPUT 2 as a Text Table and then JOIN that to your other table. The INNER join results are the ones that you want. I can mock that up if you need. -Jay

HOUEW

Thank you, Input 2 comes from multiple previous steps to get the selections. So, I can't do a text input each month as they are different results. But thank you!

jrlindem

But all of those can culminate into a list that can be used in the same way...

Whether they are in a Text Input list or they come from their own input stream, it's all the same. If your list is horizontal, you can parse it and then transpose it too.

-Jay

jrlindem

Hope that helps, -Jay

20251020_jrlindem_example.yxmd

HOUEW

Thank you! @jrlindem

binu_acs

@HOUEW Dynamic way of doing this with the help of a bath macro

DynamicFilter_20102025.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703