Forum Discussion

JDRAKE4524's avatar
JDRAKE4524
Copper Contributor
Nov 26, 2019
Solved

ISNUMBER(OR(SEARCH not producing expected results.

I am not sure why this is not working. I an no expert so bare with me. I have a column of text entries. I can use =ISNUMBER(SEARCH("CARD",D6))  to get a result TRUE/FALSE but I need to extend that ...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 27, 2019

    JDRAKE4524 

    Practically the same

    =SUM(--ISNUMBER(SEARCH({"PIN","CARD"},D6)))

    or, if return to initial formula

    =OR(ISNUMBER(SEARCH("PIN",D6)),ISNUMBER(SEARCH("CARD",D6)))

     

     

Twifoo's avatar
Twifoo
Silver Contributor
Nov 27, 2019
I haven’t tested, but you may try, this:
=SUM(COUNTIF(D6,
{“*Card*”,”*Pin*”}))>0
JDRAKE4524's avatar
JDRAKE4524
Copper Contributor
Nov 27, 2019

Twifoo 

Thank you for the assistance. This gave an error when entered as not a formula.

Resources