Forum Discussion

arisblan's avatar
arisblan
Copper Contributor
Feb 20, 2025
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      
excel
Formulas and Functions
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 21, 2025

    One more

    =FILTER( Table1, COUNTIF(Table2[Filter], Table1[Year]), "no data" )
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 21, 2025

One more

=FILTER( Table1, COUNTIF(Table2[Filter], Table1[Year]), "no data" )
  • arisblan's avatar
    arisblan
    Copper Contributor
    Feb 22, 2025

    thank you so much for your help!

  • arisblan's avatar
    arisblan
    Copper Contributor
    Feb 22, 2025

    I've been struggling with this problem...everything looks so simple when somebody tells you the solution. Thanks to everyone for helping me!

Resources