| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| look up same values in coumn1 and calculate values in 2nd column | Excel Worksheet Functions | |||
| is it possible to Restrict Find & Replace to 1 column | New Users to Excel | |||
| search a row to find the column | Excel Worksheet Functions | |||
| How sum values in column B using values in column A as the conditi | Excel Worksheet Functions | |||
Threaded Mode
