Check if cells contain the word "Thailand", return "TRUE"
 

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

Check if cells contain the word "Thailand", return "TRUE"
 

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

Check if cells contain the word "Thailand", return "TRUE"
 

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

Check if cells contain the word "Thailand", return "TRUE"
 

Hello ali
Amend Mike's formula with:
=IF(COUNTIF($A$1:$A5000,"*Thailand*")0,"True","")

HTH
Cordially
Pascal

"ali" a écrit dans le message de news:
...
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

Check if cells contain the word "Thailand", return "TRUE"
 

=SUMPRODUCT(--(ISNUMBER(FIND("Thailand",A1:A5000))))

Do not use full column range with SUMPRODUCT
This
=SUMPRODUCT(--(ISNUMBER(FIND("Thailand",A:A))))
will not work
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"ali" wrote in message
...
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

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

Check if cells contain the word "Thailand", return "TRUE"
 

Big thanks to all you guys, but i've already figured it out.

i just use " =ISERROR(SEARCH("thailand",A2,1))" , so i'll get "TRUE" and
"FALSE", and then i just re-sort them again and i'll get those entreis
containing "THAILAND"


thank you guys all anyway, ^_^!!!
--
Allen Phailat Wongakanit


"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

Check if cells contain the word "Thailand", return "TRUE"
 

On Sep 10, 1:26 pm, ali wrote:
Big thanks to all you guys, but i've already figured it out.

i just use " =ISERROR(SEARCH("thailand",A2,1))" , so i'll get "TRUE" and
"FALSE", and then i just re-sort them again and i'll get those entreis
containing "THAILAND"

thank you guys all anyway, ^_^!!!
--
Allen Phailat Wongakanit



"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- Hide quoted text -

- Show quoted text -

please view www.thaitreasuretrove for information on thailand and join
the forums to enjoy disscussions.

Stephen