Find more than a word in a table

C

Carpe Diem

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
 
D

Don Guillett

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
Click to expand...

=SUMPRODUCT(--(ISNUMBER(SEARCH({"iol","mf","af"},A1))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find in a sentence diferent word 1
Find text in N columns and one Row 1
Excel - Wich Function should I use? 1
Cumulative formula for word table 0
Create a chart from a table in word thats dynamic 0
Excel --> Word 4
Sorting Multiple Tables 1
Macro to copy table of contents to a new doc 0

Top