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.   =C...
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
Diamond Contributor
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