Jun 22 2022 05:43 AM
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.
Jun 22 2022 05:54 AM
SolutionJun 22 2022 05:59 AM
Jun 22 2022 05:54 AM
Solution=FILTER(B2:C31,ISNUMBER(MATCH($C$2:$C$31,$H$2:$H$3,0)))
You can try this formula.