If a range contains

J

Jacob Skaria

=IF(COUNTIF(A:A,"*the word text*"),"text found","Text not found")

If this post helps click Yes
 

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

If a range contains... 3
problem naming range 4
How do I exclude a cell from a range? 4
function to populate a cell where formula is NOT located 6
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
If Cell Contains specific UPPERCASE text 8
Can I use 'CONTAINS' in an IF Logical Test? 2
need a formula that uses a cell ref that contains a range name? 4

Top