Need formula to locate and validate specific text from a string
For cell B2:
=IF(OR(IF(ISERR(FIND("testing",A2)),FALSE,TRUE),IF (ISERR(FIND("cold",A2)),FALSE,TRUE),IF(ISERR(FIND( "working",A2)),FALSE,TRUE)),"Yes","No")
Fill that down to the end of your list. Remember that the formula should be
entered as one continuous line in Excel; the system here tends to break long
formulas into several lines.
"vinstream" wrote:
Hi,
I have the following sample data in column A.
germany (testing)
Germany (cold)
Germany
Austria (Testing)
Austria (cold)
Austria (working)
Austria (other)
China
China (alternate)
In column B, I want it to show that if the cell to the left has any of
the words 'testing' or 'cold' or 'working' it should show "yes" in
Column B else show "no".
Is this possible?
Regards,
Vinstream
.
|