| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find 3 If(Iserrors instead of 1
I posted this a week ago, and did get a couple of responses, but they did not
work. So I'm trying again, thinking that the wealth of knowlege here is such that, if at all possible, you all would be able to solve it. Here is my formula ( provided by this group a few months ago). =IF(ISERROR(FIND("(FLM)",MasterTab!O21)),"",MAX(A$ 1:A1)+1) it works great for (FLM), however, I now need it to also find (M)'s and (FL)'s Something like: =IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O2 1)),"",MAX(A$1:A1)+1) Is that possibe ? Thanks, Steve |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find 3 If(Iserrors instead of 1
Need a better explanation.
it works great for (FLM), however, I now need it to also find (M)'s and (FL)'s Something like: =IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O 21)),"",MAX(A$1:A1)+1) OK, does that mean: If the cell *does not* contain the string (FLM) *or* the string (FL) *or* the string (M) then return blank, otherwise return MAX(...). ??? -- Biff Microsoft Excel MVP "Steve" wrote in message ... I posted this a week ago, and did get a couple of responses, but they did not work. So I'm trying again, thinking that the wealth of knowlege here is such that, if at all possible, you all would be able to solve it. Here is my formula ( provided by this group a few months ago). =IF(ISERROR(FIND("(FLM)",MasterTab!O21)),"",MAX(A$ 1:A1)+1) it works great for (FLM), however, I now need it to also find (M)'s and (FL)'s Something like: =IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O2 1)),"",MAX(A$1:A1)+1) Is that possibe ? Thanks, Steve |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find 3 If(Iserrors instead of 1
Hopefully this will explain it from a non-expert point of view.
The O column cells have many things in them, among them the (FLM), or ((FL), or (M). My current formula is producing the result for anything that has (FLM) in it, or a blank. I need a formula that will produce the result for anything with the (FLM), but also anything with the (FL), and anything with the (M), or if none of those 3,then the blank. Thanks, Steve "T. Valko" wrote: Need a better explanation. it works great for (FLM), however, I now need it to also find (M)'s and (FL)'s Something like: =IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O 21)),"",MAX(A$1:A1)+1) OK, does that mean: If the cell *does not* contain the string (FLM) *or* the string (FL) *or* the string (M) then return blank, otherwise return MAX(...). ??? -- Biff Microsoft Excel MVP "Steve" wrote in message ... I posted this a week ago, and did get a couple of responses, but they did not work. So I'm trying again, thinking that the wealth of knowlege here is such that, if at all possible, you all would be able to solve it. Here is my formula ( provided by this group a few months ago). =IF(ISERROR(FIND("(FLM)",MasterTab!O21)),"",MAX(A$ 1:A1)+1) it works great for (FLM), however, I now need it to also find (M)'s and (FL)'s Something like: =IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O2 1)),"",MAX(A$1:A1)+1) Is that possibe ? Thanks, Steve . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find 3 If(Iserrors instead of 1
Maybe this...
=IF(COUNT(FIND({"(FLM)","(FL)","(M)"},MasterTab!O2 1)),MAX(A$1:A1)+1,"") -- Biff Microsoft Excel MVP "Steve" wrote in message ... Hopefully this will explain it from a non-expert point of view. The O column cells have many things in them, among them the (FLM), or ((FL), or (M). My current formula is producing the result for anything that has (FLM) in it, or a blank. I need a formula that will produce the result for anything with the (FLM), but also anything with the (FL), and anything with the (M), or if none of those 3,then the blank. Thanks, Steve "T. Valko" wrote: Need a better explanation. it works great for (FLM), however, I now need it to also find (M)'s and (FL)'s Something like: =IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O 21)),"",MAX(A$1:A1)+1) OK, does that mean: If the cell *does not* contain the string (FLM) *or* the string (FL) *or* the string (M) then return blank, otherwise return MAX(...). ??? -- Biff Microsoft Excel MVP "Steve" wrote in message ... I posted this a week ago, and did get a couple of responses, but they did not work. So I'm trying again, thinking that the wealth of knowlege here is such that, if at all possible, you all would be able to solve it. Here is my formula ( provided by this group a few months ago). =IF(ISERROR(FIND("(FLM)",MasterTab!O21)),"",MAX(A$ 1:A1)+1) it works great for (FLM), however, I now need it to also find (M)'s and (FL)'s Something like: =IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O2 1)),"",MAX(A$1:A1)+1) Is that possibe ? Thanks, Steve . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find 3 If(Iserrors instead of 1
That's it.
Thank you very much. Steve "T. Valko" wrote: Maybe this... =IF(COUNT(FIND({"(FLM)","(FL)","(M)"},MasterTab!O2 1)),MAX(A$1:A1)+1,"") -- Biff Microsoft Excel MVP "Steve" wrote in message ... Hopefully this will explain it from a non-expert point of view. The O column cells have many things in them, among them the (FLM), or ((FL), or (M). My current formula is producing the result for anything that has (FLM) in it, or a blank. I need a formula that will produce the result for anything with the (FLM), but also anything with the (FL), and anything with the (M), or if none of those 3,then the blank. Thanks, Steve "T. Valko" wrote: Need a better explanation. it works great for (FLM), however, I now need it to also find (M)'s and (FL)'s Something like: =IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O 21)),"",MAX(A$1:A1)+1) OK, does that mean: If the cell *does not* contain the string (FLM) *or* the string (FL) *or* the string (M) then return blank, otherwise return MAX(...). ??? -- Biff Microsoft Excel MVP "Steve" wrote in message ... I posted this a week ago, and did get a couple of responses, but they did not work. So I'm trying again, thinking that the wealth of knowlege here is such that, if at all possible, you all would be able to solve it. Here is my formula ( provided by this group a few months ago). =IF(ISERROR(FIND("(FLM)",MasterTab!O21)),"",MAX(A$ 1:A1)+1) it works great for (FLM), however, I now need it to also find (M)'s and (FL)'s Something like: =IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O2 1)),"",MAX(A$1:A1)+1) Is that possibe ? Thanks, Steve . . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find 3 If(Iserrors instead of 1
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Steve" wrote in message ... That's it. Thank you very much. Steve "T. Valko" wrote: Maybe this... =IF(COUNT(FIND({"(FLM)","(FL)","(M)"},MasterTab!O2 1)),MAX(A$1:A1)+1,"") -- Biff Microsoft Excel MVP "Steve" wrote in message ... Hopefully this will explain it from a non-expert point of view. The O column cells have many things in them, among them the (FLM), or ((FL), or (M). My current formula is producing the result for anything that has (FLM) in it, or a blank. I need a formula that will produce the result for anything with the (FLM), but also anything with the (FL), and anything with the (M), or if none of those 3,then the blank. Thanks, Steve "T. Valko" wrote: Need a better explanation. it works great for (FLM), however, I now need it to also find (M)'s and (FL)'s Something like: =IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O 21)),"",MAX(A$1:A1)+1) OK, does that mean: If the cell *does not* contain the string (FLM) *or* the string (FL) *or* the string (M) then return blank, otherwise return MAX(...). ??? -- Biff Microsoft Excel MVP "Steve" wrote in message ... I posted this a week ago, and did get a couple of responses, but they did not work. So I'm trying again, thinking that the wealth of knowlege here is such that, if at all possible, you all would be able to solve it. Here is my formula ( provided by this group a few months ago). =IF(ISERROR(FIND("(FLM)",MasterTab!O21)),"",MAX(A$ 1:A1)+1) it works great for (FLM), however, I now need it to also find (M)'s and (FL)'s Something like: =IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O2 1)),"",MAX(A$1:A1)+1) Is that possibe ? Thanks, Steve . . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find 3 If(Iserrors instead of 1
=IF(SUM(--ISNUMBER(FIND({"(FLM)","(M)","(FL)"},MasterTab!O21 ))),MAX(A$1:A1)+1)
"Steve" wrote: I posted this a week ago, and did get a couple of responses, but they did not work. So I'm trying again, thinking that the wealth of knowlege here is such that, if at all possible, you all would be able to solve it. Here is my formula ( provided by this group a few months ago). =IF(ISERROR(FIND("(FLM)",MasterTab!O21)),"",MAX(A$ 1:A1)+1) it works great for (FLM), however, I now need it to also find (M)'s and (FL)'s Something like: =IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O2 1)),"",MAX(A$1:A1)+1) Is that possibe ? Thanks, Steve |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find 3 If(Iserrors instead of 1
That's it. Thank you very much.
One more question - it's producing falses for anything that isn't the FLM, FL, or M. Could the formula be tweaked to have a blank there instea of thee false ? Thanks again, Steve "Teethless mama" wrote: =IF(SUM(--ISNUMBER(FIND({"(FLM)","(M)","(FL)"},MasterTab!O21 ))),MAX(A$1:A1)+1) "Steve" wrote: I posted this a week ago, and did get a couple of responses, but they did not work. So I'm trying again, thinking that the wealth of knowlege here is such that, if at all possible, you all would be able to solve it. Here is my formula ( provided by this group a few months ago). =IF(ISERROR(FIND("(FLM)",MasterTab!O21)),"",MAX(A$ 1:A1)+1) it works great for (FLM), however, I now need it to also find (M)'s and (FL)'s Something like: =IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O2 1)),"",MAX(A$1:A1)+1) Is that possibe ? Thanks, Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| 'find' somtimes can't find numbers. I folowd the 'help' instructi. | Excel Worksheet Functions | |||
| How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
Hybrid Mode
