Find a word in a sentence
Two things...
First, I left out the sheet reference, so my post should have been this...
=IF(Sheet1!A1="","",LEFT("X",COUNTIF(Sheet1!A1,"*a lready*")=0))
Second, if you *really* meant "text" as your post said, meaning pure numbers
should not return an "X", then use this instead...
=IF(ISNUMBER(Sheet1!A1),"",LEFT("X",COUNTIF(Sheet1 !A1,"*already*")=0))
--
Rick (MVP - Excel)
"Rick Rothstein" wrote in message
...
Here is another way...
=IF(A1="","",LEFT("X",COUNTIF(A1,"*already*")=0))
--
Rick (MVP - Excel)
"Chicago2Paris" wrote in message
...
I searched the board, but couldn't find an exact answer to my issue, so
I'm
looking for some help.
I have a column that may contain text or may be blank.
I want to place an "x" on another sheet if:
1. There is text in the cell AND
2. The cell does not contain the word "Already" in the sentence
Thanks!
|