Filter based on the result of another filtering

lity125

Hi all, I would like to filter the records with below criteria to a new sheet (sheet 1)

1. with amount >=500 or

2. with amount >=100 and with name in the list of above criteria

Then, filter the records with below criteria to another new sheet (sheet 2)

1. with amount >=100 and

2. not in sheet 1

I stuck in filtering of sheet 1. I can filter criteria 1 but have no idea on how to filter criteria 2 that need to base on the result of criteria 1. Is there anyone can help? Thanks.

RolandSchubert

Hi @lity125 ,

if I got you right, you have to "decomposite" your conditions.

Step 1: Find the rows with Amount >= 500
Step 2: Find Unique names in the result of step 1
Step 3: Find Amount >= 100 and < 500
Step 4: Join result of steps 2+3 (should be your second condition

For the second sheet, your have to find Amount >= 100 and remove the rows already in sheet 1 ("R" output anchor of Joni tool.

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland

Filter.yxmd