doing a formula find across multiple cells

  • Thread starter Robert Flanagan
  • Start date
R

Robert Flanagan

Is there a way to do a find for text within the text in a group of cells?
For example, cells may contain any text: "abc", "kek", "abbbfff", and I
want to test if any cell on the row contains the letter "e" and if so return
True. If none of the cell entries contain "b", then I want the answer to be
false. I can do it on a single cell, but can not figureout how to do on a
range. I know I can do with a macro, but would like a formula.

Thanks for any help

Bob
 
R

RagDyeR

Try this:

=COUNTIF(A1:Z1,"*e*")>0

You could also use a designated cell to contain your criteria, so that you
could change it without having to revise the formula itself:

=COUNTIF(A1:Z1,"*"&A5&"*")>0
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Is there a way to do a find for text within the text in a group of cells?
For example, cells may contain any text: "abc", "kek", "abbbfff", and I
want to test if any cell on the row contains the letter "e" and if so return
True. If none of the cell entries contain "b", then I want the answer to be
false. I can do it on a single cell, but can not figureout how to do on a
range. I know I can do with a macro, but would like a formula.

Thanks for any help

Bob
 

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

Top