SOLVED

Filter Function OR Condition

%3CLINGO-SUB%20id%3D%22lingo-sub-3537798%22%20slang%3D%22en-US%22%3EFilter%20Function%20OR%20Condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3537798%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DFILTER(Data%3B(Data%5BResource%20Name%5D%3DH2)%2B(Data%5BResource%20Name%5D%3DH3))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20how%20to%20use%20filter%20function%20for%20or%20condition.%20But%20i%20don't%20want%20to%20select%20all%20contitions%20one%20by%20one%20with%20%22%2B%22%20symbol.%20Instead%20i%20want%20to%20select%20them%20totally%20in%20a%20dynamic%20way.%20Is%20it%20possible%20to%20do%20it%3F%20How%20can%20i%20state%20%22each%20of%20them%22%20in%20excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%20the%20document%20which%20doesn't%20include%20sensitive%20data.%20It%20is%20a%20basic%20data%20set%20instead%20of%20complex%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3537798%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3537898%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Function%20OR%20Condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3537898%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F589847%22%20target%3D%22_blank%22%3E%40Sekoleyte%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DFILTER(B2%3AC31%2CISNUMBER(MATCH(%24C%242%3A%24C%2431%2C%24H%242%3A%24H%243%2C0)))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EYou%20can%20try%20this%20formula.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22filter%20function%20or%20condition.JPG%22%20style%3D%22width%3A%20773px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22filter%20function%20or%20condition.JPG%22%20style%3D%22width%3A%20773px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22filter%20function%20or%20condition.JPG%22%20style%3D%22width%3A%20773px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22filter%20function%20or%20condition.JPG%22%20style%3D%22width%3A%20773px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22filter%20function%20or%20condition.JPG%22%20style%3D%22width%3A%20773px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22filter%20function%20or%20condition.JPG%22%20style%3D%22width%3A%20773px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F382668i6CEE9AA56DB3A0B8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22filter%20function%20or%20condition.JPG%22%20alt%3D%22filter%20function%20or%20condition.JPG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3537955%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Function%20OR%20Condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3537955%22%20slang%3D%22en-US%22%3EThank%20you%20for%20your%20quick%20help.%20That%20is%20what%20i%20really%20want%20to%20do.%3C%2FLINGO-BODY%3E
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 (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.