Prev: Changing a formula to read a general value?
Next: FORMULA'S
From: Steve on 13 May 2010 16:38
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
From: Ashish Mathur on 13 May 2010 19:55
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" <Steve(a)discussions.microsoft.com> wrote in message
news:2BBC5A81-3064-43CF-BF1C-7BDFEF0FB01F(a)microsoft.com...
> 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

From: Jacob Skaria on 14 May 2010 01:03
Hi Steve

Try

=IF(COUNT(FIND({"FLM","FL","M"},MasterTab!O21)),MAX(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
From: Steve on 14 May 2010 11:48
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 re: 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" <Steve(a)discussions.microsoft.com> wrote in message
> news:2BBC5A81-3064-43CF-BF1C-7BDFEF0FB01F(a)microsoft.com...
> > 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
>
From: Steve on 14 May 2010 11:49
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 re: 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)),MAX(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
 | 
Pages: 1
Prev: Changing a formula to read a general value?
Next: FORMULA'S