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" )
Alternatively
= FILTER(Table1, BYROW(Table1[Year]=TOROW(Table2), OR))
thank you so much for your help!