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" )
=FILTER(Table1, ISNUMBER(XMATCH(Table1[YEAR], Table2[FILTER])), "")
everything works!! thank you so much