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

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

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

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




.

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




.

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

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




.



.

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




.



.