Forum Discussion
Sekoleyte
Jun 22, 2022Iron Contributor
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.
2 Replies
Sort By
- OliverScheurichGold Contributor
- SekoleyteIron ContributorThank you for your quick help. That is what i really want to do.