| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing one text with three in IF(ISERROR(FIND.......Max
Hi,
I have not tried this - please check if it works =IF(ISERROR(FIND({"FLM","FL","M"},MasterTab!O21)), "",MAX(A$1:A1)+1) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Steve" wrote in message ... I have this formula. =IF(ISERROR(FIND("Relief",MasterTab!O21)),"",MAX(A $1:A1)+1) can it be modified to find three different things instead of "relief". I'd like it to find: (FLM) (FL) and (M) ? Much thanks, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing ISERROR Formula | Excel Worksheet Functions | |||
| Macro - Fixed text code needs replacing with variable text | Excel Discussion (Misc queries) | |||
| Int Iserror Len Mid Find formula | Excel Worksheet Functions | |||
| replacing text in all cells with existing text plus something | Excel Discussion (Misc queries) | |||
| INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
