IF cell contains certain text return value
Many thanks for this one slight problem is that the cell A1 contains words
too for example "Secondary Checking" or "Check process two" - so I need to
identify cells that contain "Check" or "Checking"?
"Sam Wilson" wrote:
If your row with the text was row 1, and you wanted row 2 to have
Doing/Checking in it, type the following in cell B1 and copy it along:
=IF(OR(A1="Check",A1="Checking"),"Checking","Doing ")
"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
|