Check if cells contain the word "Thailand", return "TRUE"
Then perhaps is MIGHT
=SUMPRODUCT(ISNUMBER(SEARCH("~Thailand",A1:A100))+ 0)0
Mike
"ali" wrote:
Thanks a lot for the reply first!
However, this is NOT working ! !
this formula returns cells "exactly equals" to "Thailand" , not "Containing"
the word "Thailand"
is there any other way to get it ?
--
Allen Phailat Wongakanit
"Mike H" wrote:
Try this
=IF(COUNTIF($A$1:$A5000,"Thailand")0,"True","")
Mike
"ali" wrote:
I have a spread sheet (5000 entries)
i have an extra column at the end.
I'd like to generate a formula which find if my data in column A (A1:A5000)
contans the word "Thailand".
if it containt the word "Thailand" , i shall get a sign (or an indicator,
say... "TURE", something like that)
--
Allen Phailat Wongakanit
|