| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to locate and validate specific text from a string
One mo
=IF(SUM(COUNTIF(A1,"*"&{"testing","working","cold" }&"*"))0,"Yes","No") You could actually leave the "0" out of the expression. But I think it makes the formula easier to understand. vinstream wrote: Hi, I have the following sample data in column A. germany (testing) Germany (cold) Germany Austria (Testing) Austria (cold) Austria (working) Austria (other) China China (alternate) In column B, I want it to show that if the cell to the left has any of the words 'testing' or 'cold' or 'working' it should show "yes" in Column B else show "no". Is this possible? Regards, Vinstream -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| locate cell with specific text and select that column | Excel Discussion (Misc queries) | |||
| Formula to extract a specific word from text string | Excel Worksheet Functions | |||
| Locate and count the recurrences of a text string | Excel Discussion (Misc queries) | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
Threaded Mode
