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 "+" 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.

Resources