| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update to formula
Is it possible for a formula to look in cell and check if it contains
specific text? I was provided the following formula, below, but it only checks to see if cell value contains only those values but not if it includes it. For example: cell value - Test0408AU ="Exist" =IF(COUNT(SEARCH({"Q3","0308","Q#3","0408AU","0408 SL","0408","0109","0209","0309","0409"},A1)),"Exis t","Cannot find") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update formula in column when another cell formula is changed | Excel Worksheet Functions | |||
| formula wont update | Excel Discussion (Misc queries) | |||
| Update cells formula | Excel Worksheet Functions | |||
| Formula won't update with new data | New Users to Excel | |||
| I want to update the formula in a spreadsheet from 04 to 05. Is . | Excel Worksheet Functions | |||
Threaded Mode
