Replacing one text with three in IF(ISERROR(FIND.......Max
 

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

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

Replacing one text with three in IF(ISERROR(FIND.......Max
 

Hi Steve

Try

=IF(COUNT(FIND({"FLM","FL","M"},MasterTab!O21)),MA X(A$1:A1)+1,"")

--
Jacob (MVP - Excel)


"Steve" wrote:

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

Replacing one text with three in IF(ISERROR(FIND.......Max
 

I can't get it to work, but maybe it was my fault, in pasting a slightly
different formula.
This is the one that works well
=IF(ISERROR(FIND("(FLM)",MasterTab!21)),"",MAX(A$1 :A1)+1)
for FLM, but still need it for FLM FL & M
Question array. Are those brackets denoting an array ? Do I enter those,
and then SHIFT-CTRL [E], or are they automatically entered ?

Thanks again,

Steve
"Ashish Mathur" wrote:

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

Replacing one text with three in IF(ISERROR(FIND.......Max
 

I can't get it to work, but maybe it was my fault, in pasting a slightly
different formula.
This is the one that works well
=IF(ISERROR(FIND("(FLM)",MasterTab!21)),"",MAX(A$1 :A1)+1)
for FLM, but still need it for FLM FL & M
Question array. Are those brackets denoting an array ? Do I enter those,
and then SHIFT-CTRL [E], or are they automatically entered ?

Thanks again,

Steve


"Jacob Skaria" wrote:

Hi Steve

Try

=IF(COUNT(FIND({"FLM","FL","M"},MasterTab!O21)),MA X(A$1:A1)+1,"")

--
Jacob (MVP - Excel)


"Steve" wrote:

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