Search cell for any of 6 criteria

  • Thread starter Thread starter Pierre
  • Start date Start date
P

Pierre

Have cells containing numerous text strings.
If the cell contains within its contents (which also has other
characters:)

.12 or .19 or TRS or PKI or .099 or PCI

Want to return TRUE, or FALSE.

Tried incarnations of this, but it doesn't behave.
=ISNUMBER(SEARCH("*.12*","*.19*","*TRS*","*PKI*","*.099*","*PCI*",A1))

Thanks for ideas.

Pierre
 
Try this:
=OR(COUNTIF(A1,"*"&{".12",".19","TRS","PKI",".099","PCI"}&"*"))

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)
 
Try this:
=OR(COUNTIF(A1,"*"&{".12",".19","TRS","PKI",".099","PCI"}&"*"))

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)











- Show quoted text -
Click to expand...


Ron, thank you!

Pierre
 
Back
Top