Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search cell for any of 6 criteria
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search cell for any of 6 criteria
Try this:
=OR(COUNTIF(A1,"*"&{".12",".19","TRS","PKI",".099" ,"PCI"}&"*")) Is that something you can work with? Regards, Ron Coderre Microsoft MVP (Excel) "Pierre" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search cell for any of 6 criteria
On Mar 24, 11:16*am, "Ron Coderre" wrote:
Try this: =OR(COUNTIF(A1,"*"&{".12",".19","TRS","PKI",".099" ,"PCI"}&"*")) Is that something you can work with? Regards, Ron Coderre Microsoft MVP (Excel) "Pierre" wrote in message ... 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- Hide quoted text - - Show quoted text - Ron, thank you! Pierre |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search cell for any of 6 criteria
Amending your formula...
=OR(ISNUMBER(SEARCH({".12",".19","TRS","PKI",".099 ","PCI"},A1))) Hope this helps! Domenic www.xl-central.com In article , Pierre wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple search criteria | Excel Worksheet Functions | |||
Search criteria please | Excel Discussion (Misc queries) | |||
Search Criteria Prompting | Excel Discussion (Misc queries) | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Search Range for Criteria in given cell and produce results | Excel Discussion (Misc queries) |