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

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))))

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))))

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