I'm trying to write a logical test that means: if (any cell in range a:a)
J Jacob Skaria Oct 1, 2009 #2 =IF(COUNTIF(A:A,"*the word text*"),"text found","Text not found") If this post helps click Yes
