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