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" )
One more
=FILTER( Table1, COUNTIF(Table2[Filter], Table1[Year]), "no data" )
thank you so much for your help!