Forum Discussion
Solved
Dynamic Array filter multiple values
Is there a method to use the FILTER formula for filtering "table 1" based on values of table 2 thanks for helping
One more
=FILTER( Table1, COUNTIF(Table2[Filter], Table1[Year]), "no data" )
PeterBartholomew1 , IMHO, that's overcomplicated. You iterate criteria and stack them into result with high-level functions. Calc engine in any of xxIFS function combines criteria on boolean AND applying filter to source data. My guess calc engine shall do that more efficiency.
Agreed.