SOLVED

ISNUMBER(SEARCH

%3CLINGO-SUB%20id%3D%22lingo-sub-3544895%22%20slang%3D%22en-US%22%3EISNUMBER(SEARCH%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3544895%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20wondering%20if%20it%20possible%20to%20have%20multiple%26nbsp%3BISNUMBER(SEARCH%20functions%20in%20a%20formula.%20I%20am%20currently%20using%20this%20formula%20but%20only%20the%20first%26nbsp%3BISNUMBER(SEARCH%20seems%20to%20be%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCOUNTA(UNIQUE(FILTER('Iri%20Comp%20Data'!K%3AK%2C('Iri%20Comp%20Data'!C%3AC%26lt%3B%3D200)*ISNUMBER(SEARCH(%22Sobeys%22%2C'Iri%20Comp%20Data'!O%3AO)*ISNUMBER(SEARCH(%22ON%22%2C'Iri%20Comp%20Data'!%24S%3A%24S))))))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3544895%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-3545060%22%20slang%3D%22en-US%22%3ERe%3A%20ISNUMBER(SEARCH%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3545060%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1415563%22%20target%3D%22_blank%22%3E%40Renattae_Schmidt%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerenties%20were%20using%20wrongly%2C%20it%20shall%20be%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DCOUNTA(%0A%20%20%20UNIQUE(%0A%20%20%20FILTER(%20'Iri%20Comp%20Data'!K%3AK%2C%0A%20%20%20%20%20%20%20%20%20%20%20('Iri%20Comp%20Data'!C%3AC%26lt%3B%3D200)%20*%0A%20%20%20%20%20%20%20%20%20%20%20ISNUMBER(SEARCH(%22Sobeys%22%2C'Iri%20Comp%20Data'!O%3AO)%20)%20*%0A%20%20%20%20%20%20%20%20%20%20%20ISNUMBER(%20SEARCH(%20%22ON%22%2C'Iri%20Comp%20Data'!%24S%3A%24S%20))%20)))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3545066%22%20slang%3D%22en-US%22%3ERe%3A%20ISNUMBER(SEARCH%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3545066%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1415563%22%20target%3D%22_blank%22%3E%40Renattae_Schmidt%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCOUNTA(UNIQUE(FILTER('Iri%20Comp%20Data'!K%3AK%2C('Iri%20Comp%20Data'!C%3AC%26lt%3B%3D200)*ISNUMBER(SEARCH(%22Sobeys%22%2C'Iri%20Comp%20Data'!O%3AO)*ISNUMBER(SEARCH(%22ON%22%2C'Iri%20Comp%20Data'!%24S%3A%24S))))%3CFONT%20color%3D%22%23CF3600%22%3E)%3C%2FFONT%3E)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20above%20formula%20i%20removed%20%22%20%3CFONT%20color%3D%22%23CF3600%22%3E)%3C%2FFONT%3E%20%22%20and%20added%20it%20as%20shown%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCOUNTA(UNIQUE(FILTER('Iri%20Comp%20Data'!K%3AK%2C('Iri%20Comp%20Data'!C%3AC%26lt%3B%3D200)*ISNUMBER(SEARCH(%22Sobeys%22%2C'Iri%20Comp%20Data'!O%3AO)%3CFONT%20color%3D%22%23CF3600%22%3E)%3C%2FFONT%3E*ISNUMBER(SEARCH(%22ON%22%2C'Iri%20Comp%20Data'!%24S%3A%24S)))))%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello all,

 

I was wondering if it possible to have multiple ISNUMBER(SEARCH functions in a formula. I am currently using this formula but only the first ISNUMBER(SEARCH seems to be working.

 

=COUNTA(UNIQUE(FILTER('Iri Comp Data'!K:K,('Iri Comp Data'!C:C<=200)*ISNUMBER(SEARCH("Sobeys",'Iri Comp Data'!O:O)*ISNUMBER(SEARCH("ON",'Iri Comp Data'!$S:$S))))))

 

Thank you!

1 Reply
best response confirmed by Renattae_Schmidt (Occasional Contributor)
Solution

@Renattae_Schmidt 

Perenties were using wrongly, it shall be like

=COUNTA(
   UNIQUE(
   FILTER( 'Iri Comp Data'!K:K,
           ('Iri Comp Data'!C:C<=200) *
           ISNUMBER(SEARCH("Sobeys",'Iri Comp Data'!O:O) ) *
           ISNUMBER( SEARCH( "ON",'Iri Comp Data'!$S:$S )) )))