Merge multiple FILTER function results

[JugglerJAF]

I have two separate tables (which must remain separate), each of which has a FILTER function applied. The first FILTER returns (ten) employee names from Table1 where the Age is between 21 and 30, the second returns (five) employee names from Table2 where the department is IT. So far so good...

What I now want to do is to keep the two filters I already have, but create a "master" list that combines all names from each of the FILTER formula results.

Possible??

 

[Fluff]

How about

=LET(RngA,I2#,RngB,K2#,r,ROWS(RngA),s,SEQUENCE(r+ROWS(RngB)),IF(s<=r, RngA, INDEX(RngB, s-r)))

 

[JugglerJAF]

How about

=LET(RngA,I2#,RngB,K2#,r,ROWS(RngA),s,SEQUENCE(r+ROWS(RngB)),IF(s<=r, RngA, INDEX(RngB, s-r)))

That works a treat, many thanks! I'm just trying to get my head around how it works and what it's doing

Would it be possible to expand that to combine 3 or more FILTER function outputs?

 

[Fluff]

Yes you can do that like

=LET(RngA,I2#,RngB,K2#,RngC,M2#,ra,ROWS(RngA),rb,ra+ROWS(RngB),s,SEQUENCE(rb+ROWS(RngC)),IF(s<=ra, RngA,IF(s<=rb,INDEX(RngB, s-ra),INDEX(RngC,s-rb))))