| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding Values in a cell
I have cells that have phrases written in them. Now I wish to assign a value
to the corresponding cell in the next column if a particular word is present in the phrase. e.g. Column A Column B Johnny Passed the exam If A1 contains Johnny, write 1 else 2 Rita missed the train If A1 contains Johnny, write 1 else 2 How do I achieve the formula for column B? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
| Finding Min Cell values excluding zero in alternate columns | Excel Worksheet Functions | |||
| Finding Min Cell values excluding zero in alternate columns | Excel Worksheet Functions | |||
| finding cell values | Excel Discussion (Misc queries) | |||
| finding values and displaying adjacent values | Excel Worksheet Functions | |||
Threaded Mode
