| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find more than a word in a table
Hi,
I need to find in a table in one column and X rows more then one word. Example: A1 = mercedes_xpto_iol_mrec_jun A2 = mercedes_xpto_af_mrec_jun A3= mercedes_xpto_mf_mrec_jun I need to see if there is the word "IOL" or the word "AF" or "MF" in each cell, but only one could be there. In A1 IOL In A2 AF In A3 MF Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find more than a word in a table
On Jul 14, 6:51*am, Carpe Diem wrote:
Hi, I need to find in a table in one column and *X rows more then one word. Example: A1 = mercedes_xpto_iol_mrec_jun A2 = mercedes_xpto_af_mrec_jun A3= mercedes_xpto_mf_mrec_jun I need to see if there is the word "IOL" or the word "AF" or "MF" in each cell, but only one could be there. In A1 IOL In A2 AF In A3 MF Thank you =SUMPRODUCT(--(ISNUMBER(SEARCH({"iol","mf","af"},A1)))) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find more than a word in a table
On Jul 14, 8:26*am, Don Guillett wrote:
On Jul 14, 6:51*am, Carpe Diem wrote: Hi, I need to find in a table in one column and *X rows more then one word. Example: A1 = mercedes_xpto_iol_mrec_jun A2 = mercedes_xpto_af_mrec_jun A3= mercedes_xpto_mf_mrec_jun I need to see if there is the word "IOL" or the word "AF" or "MF" in each cell, but only one could be there. In A1 IOL In A2 AF In A3 MF Thank you =SUMPRODUCT(--(ISNUMBER(SEARCH({"iol","mf","af"},A1)))) Safer =SUMPRODUCT(--(ISNUMBER(SEARCH({"_iol_","_mf_","_af_"},A1)))) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find more than a word in a table
Hi,
another way: =COUNT(SEARCH({"iol";"af";"mf"},A1)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a word in a table, then use a function | Excel Worksheet Functions | |||
| Macro to find a word and copy all rows with this word to diff ws | Excel Programming | |||
| Link table from excel to word using word VBA | Excel Discussion (Misc queries) | |||
| Link table from excel to word using word VBA | Excel Programming | |||
| macro to intsert a word using the "Find" command to search for a word | Excel Programming | |||
Linear Mode
