SOLVED

Filter Function OR Condition

Iron Contributor

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 "+" symbol. Instead i want to select them totally in a dynamic way. Is it possible to do it? How can i state "each of them" in excel?

 

Please check the document which doesn't include sensitive data. It is a basic data set instead of complex one.

 

Thanks in advance for your help.

2 Replies
best response confirmed by Sekoleyte (Iron Contributor)
Solution

@Sekoleyte 

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

You can try this formula.

filter function or condition.JPG 

Thank you for your quick help. That is what i really want to do.
1 best response

Accepted Solutions
best response confirmed by Sekoleyte (Iron Contributor)
Solution

@Sekoleyte 

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

You can try this formula.

filter function or condition.JPG 

View solution in original post