Forum Discussion

Renattae_Schmidt's avatar
Renattae_Schmidt
Copper Contributor
Jun 23, 2022
Solved

ISNUMBER(SEARCH

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!

excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 23, 2022

    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 )) )))
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jun 23, 2022

    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 )) )))

Resources