0

I am trying to get my array formula to be able to filter on multiple drop down menus. I have 2 separate formulas that work but I cannot combine them. Is there a way to combine them to make the Array formula filter on multiple criteria?

Array formula:

=ArrayFormula(if(B1="All",Sheet2!A1:AF:{{Sheet2!A1:AF1};filter(Sheet2!A2:AF,Sheet2!A2:A=B1)}))

Multiple filter formula:

=filter(filter(Sheet2!A1:L8, (Sheet2!A1:L1=B2)+(Sheet2!A1:L1="All")), Sheet2!A1:A8=B1)

Link to the spreadsheet updated to share with anyone: https://docs.google.com/spreadsheets/d/11rfgF8TQXeCNIkQE1Wklckdwrsu7N6Um2h_i4k1-1JU/edit?usp=sharing

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.