Find

  • Thread starter Thread starter Slim Slender
  • Start date Start date
S

Slim Slender

"mystring" might occur in any one of or even several of a number of
columns in a table in any row in a table. I need to identify the
occurances.
If I put =find(mystring,b2) in A2 I could catch it if it was in B2 but
how could I catch it in the other columns and rows?
 
"mystring" might occur in any one of or even several of a number of
columns in a table in any row in a table. I need to identify the
occurances.
If I put =find(mystring,b2) in A2 I could catch it if it was in B2 but
how could I catch it in the other columns and rows?
Click to expand...

I "If desired, send your file to dguillett @gmail.com I will only
look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."
would suggest a macro using edit>find>>>>> Record while doing
 
"mystring" might occur in any one of or even several of a number of
columns in a table in any row in a table. I need to identify the
occurances.
If I put =find(mystring,b2) in A2 I could catch it if it was in B2 but
how could I catch it in the other columns and rows?
Click to expand...

I think it might be possible with an array formula but I'm struggling
to find the answer. I'll keep at it and hopefully have something for
you.

Matthew
http://2toria.com
http://teachr.blogspot.com
 
"mystring" might occur in any one of or even several of a number of
columns in a table in any row in a table. I need to identify the
occurances.
If I put =find(mystring,b2) in A2 I could catch it if it was in B2 but
how could I catch it in the other columns and rows?
Click to expand...

Try this formula:
=SUMPRODUCT(1-ISERROR(FIND(mystring,B2:E10)))

Change B2:E10 to fit the size of your table.

Hope this helps / Lars-Åke
 
Back
Top