Forum Discussion
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 ...
Practically the same
=SUM(--ISNUMBER(SEARCH({"PIN","CARD"},D6)))or, if return to initial formula
=OR(ISNUMBER(SEARCH("PIN",D6)),ISNUMBER(SEARCH("CARD",D6)))
I haven’t tested, but you may try, this:
=SUM(COUNTIF(D6,
{“*Card*”,”*Pin*”}))>0
=SUM(COUNTIF(D6,
{“*Card*”,”*Pin*”}))>0
Thank you for the assistance. This gave an error when entered as not a formula.
