How do I filter 3 multiple sheets into one sheet.

Question

How do I filter 3 multiple sheets into one sheet.

Anonymous

Hi,

How do I filter 3 multiple sheets into one sheet using the filter function with one condition? I have 3 sheets with the same format and ranges but have different data. I want to filter them all in one sheet but with one condition. It should include the data in columns B to K and it only captures all the "Yes" in the "Active" Column.

pLease help. thank you

This is my current formula =IF(FILTER('CS - MNL'!B12:K1000,'CS - MNL'!H12:H1000="Yes")=0,"",FILTER('CS - MNL'!B12:K1000,'CS - MNL'!H12:H1000="Yes"))

I also want to add an "IF" function for the blank cells to return as 0.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

Answer accepted by question author

0 additional answers

Answer 1

Anonymous

Hi,

Enter this formula

=LET(r,VSTACK(Sheet1!A2:B4,Sheet2!A2:B4,Sheet3!A2:B4),FILTER(r,INDEX(r,,2)="Yes"))

Share via

How do I filter 3 multiple sheets into one sheet.

0 additional answers