Find values in a column
 

Dear all,
in a colomun I would lik to find out a certain word (alone or part of few
other words) and get the result True or Falso in another column.
For example

A B
house True
housewife True
house in a village True
home False
isolated house True

Thanks for your help and regards
John

Try...

B1, copied down:

=ISNUMBER(SEARCH("house",A1))

Hope this helps!

In article , "John"
wrote:

Dear all,
in a colomun I would lik to find out a certain word (alone or part of few
other words) and get the result True or Falso in another column.
For example

A B
house True
housewife True
house in a village True
home False
isolated house True

Thanks for your help and regards
John

Hi John

In B1 and down: =IF(ISERROR(FIND("house",A1,1)),"False","True")
--
ve_2nd_at. Randburg, Gauteng, South Africa


"John" wrote:

Dear all,
in a colomun I would lik to find out a certain word (alone or part of few
other words) and get the result True or Falso in another column.
For example

A B
house True
housewife True
house in a village True
home False
isolated house True

Thanks for your help and regards
John

Yes, it works fine.
Thanks
John
"Domenic" ha scritto nel messaggio
...
Try...

B1, copied down:

=ISNUMBER(SEARCH("house",A1))

Hope this helps!

In article , "John"
wrote:

Dear all,
in a colomun I would lik to find out a certain word (alone or part of few
other words) and get the result True or Falso in another column.
For example

A B
house True
housewife True
house in a village True
home False
isolated house True

Thanks for your help and regards
John