Forum Discussion

Sekoleyte's avatar
Sekoleyte
Iron Contributor
Jun 22, 2022
Solved

Filter Function OR Condition

Hi there.   =FILTER(Data;(Data[Resource Name]=H2)+(Data[Resource Name]=H3))   I know how to use filter function for or condition. But i don't want to select all contitions one by one with "+" sym...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jun 22, 2022

    Sekoleyte 

    =FILTER(B2:C31,ISNUMBER(MATCH($C$2:$C$31,$H$2:$H$3,0)))

    You can try this formula.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jun 22, 2022

Sekoleyte 

=FILTER(B2:C31,ISNUMBER(MATCH($C$2:$C$31,$H$2:$H$3,0)))

You can try this formula.

 

Sekoleyte's avatar
Sekoleyte
Iron Contributor
Jun 22, 2022
Thank you for your quick help. That is what i really want to do.

Resources