Forum Discussion

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

ISNUMBER(SEARCH( range

Hello All,    I am trying to count the unique values in column K, assuming column O has west and column C is less <= 200. The below is the formula I am using, but I get a 1.    =COUNTA(UNIQUE(FIL...
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Jun 23, 2022

    Hi Renattae_Schmidt 

     

    In what you posted there's an uncertainty regarding the content of column C in 'Iri Comp Data'. Assuming that column contains Numbers and not Text values, the following should do what you want (sample attached):

     

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

    Sample attached

     

    If this doesn't work please upload & share a workbook, i.e. with OneDrive, Google Drive... and post the link here

Lorenzo's avatar
Lorenzo
Silver Contributor
Jun 23, 2022

Hi Renattae_Schmidt 

 

In what you posted there's an uncertainty regarding the content of column C in 'Iri Comp Data'. Assuming that column contains Numbers and not Text values, the following should do what you want (sample attached):

 

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

Sample attached

 

If this doesn't work please upload & share a workbook, i.e. with OneDrive, Google Drive... and post the link here

Resources