IF cell contains certain text return value
On Tuesday, June 30, 2009 at 4:38:01 PM UTC+7, Jacob Skaria wrote:
If this is one cell
try
=IF(COUNTIF(A1,"*check*"),"Checking","Doing")
Since you mentioned row...try the below as well It checks for these words in
Cols A to J for the first row. Copy down as required.
=IF(COUNTIF(A1:J1,"*check*"),"Checking","Doing")
If this post helps click Yes
---------------
Jacob Skaria
"Eán" wrote:
I have a row containing various text including the words 'Check' &
'Checking'; in a separate row I would like to identify all the cells which
include 'Check' or 'Checking' and return the text "Checking" if it contains
either 'Check' or 'Checking' or "Doing" if it doesn't.
Hope this makes sense?
Many thanks
what should I do, when I have to find 2 different texts ?
|