Array Formula w/ COLUMN & MATCH FUNCTIONS

I am using the following array formula
=MATCH(1,(B10:H10+B15:H15>100)*(COLUMN(B1:H1)<>COLUMN(C1)),0) and was
wondering what would be the syntax that would allow me to ignore more than
one column (let's say "E").

Also, was wondering if there is a way to write the formula so that in
addition to avoid reviewing column "c" in the above formula there is a way to
avoid having return "2" it doesn't count it (i.e., if a match is found in
column "d" then instead of returning the number "3" it returns "2" because
"c" doesn't count). Thanks again

=MATCH(1,(B10:H10+B15:H15>100)*(COLUMN(B1:H1)<>COLUMN(C1))*(COLUMN(B1:H1)<>COLUMN(E1)),0)

HTH
--
AP

"SJT" <[email protected]> a écrit dans le message de news:
[email protected]...
>I am using the following array formula
> =MATCH(1,(B10:H10+B15:H15>100)*(COLUMN(B1:H1)<>COLUMN(C1)),0) and was
> wondering what would be the syntax that would allow me to ignore more than
> one column (let's say "E").
>
> Also, was wondering if there is a way to write the formula so that in
> addition to avoid reviewing column "c" in the above formula there is a way
> to
> avoid having return "2" it doesn't count it (i.e., if a match is found in
> column "d" then instead of returning the number "3" it returns "2" because
> "c" doesn't count). Thanks again
>

My previous post does not answer your 2nd question.

Cheers,
--
AP

"SJT" <[email protected]> a écrit dans le message de news:
[email protected]...
>I am using the following array formula
> =MATCH(1,(B10:H10+B15:H15>100)*(COLUMN(B1:H1)<>COLUMN(C1)),0) and was
> wondering what would be the syntax that would allow me to ignore more than
> one column (let's say "E").
>
> Also, was wondering if there is a way to write the formula so that in
> addition to avoid reviewing column "c" in the above formula there is a way
> to
> avoid having return "2" it doesn't count it (i.e., if a match is found in
> column "d" then instead of returning the number "3" it returns "2" because
> "c" doesn't count). Thanks again
>

Thanks for your help. Is it possible to do what I inquired about in the
second half of the question?

"Ardus Petus" wrote:

> My previous post does not answer your 2nd question.
>
> Cheers,
> --
> AP
>
> "SJT" <[email protected]> a écrit dans le message de news:
> [email protected]...
> >I am using the following array formula
> > =MATCH(1,(B10:H10+B15:H15>100)*(COLUMN(B1:H1)<>COLUMN(C1)),0) and was
> > wondering what would be the syntax that would allow me to ignore more than
> > one column (let's say "E").
> >
> > Also, was wondering if there is a way to write the formula so that in
> > addition to avoid reviewing column "c" in the above formula there is a way
> > to
> > avoid having return "2" it doesn't count it (i.e., if a match is found in
> > column "d" then instead of returning the number "3" it returns "2" because
> > "c" doesn't count). Thanks again
> >
>
>
>

Do you mean

=MATCH(TRUE,(B10:H10+B15:H15>100),0)-1

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Ardus Petus" <[email protected]> wrote in message
news:#faUJ#[email protected]...
> My previous post does not answer your 2nd question.
>
> Cheers,
> --
> AP
>
> "SJT" <[email protected]> a écrit dans le message de news:
> [email protected]...
> >I am using the following array formula
> > =MATCH(1,(B10:H10+B15:H15>100)*(COLUMN(B1:H1)<>COLUMN(C1)),0) and was
> > wondering what would be the syntax that would allow me to ignore more
than
> > one column (let's say "E").
> >
> > Also, was wondering if there is a way to write the formula so that in
> > addition to avoid reviewing column "c" in the above formula there is a
way
> > to
> > avoid having return "2" it doesn't count it (i.e., if a match is found
in
> > column "d" then instead of returning the number "3" it returns "2"
because
> > "c" doesn't count). Thanks again
> >
>
>