I am using the following array formula
=MATCH(1,(B10:H10+B15:H15100)*(COLUMN(B1:H1)<COL UMN(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:H15100)*(COLUMN(B1:H1)<COL UMN(C1))*(COLUMN(B1:H1)<COLUMN(E1)),0)

HTH
--
AP

"SJT" a écrit dans le message de news:
...
I am using the following array formula
=MATCH(1,(B10:H10+B15:H15100)*(COLUMN(B1:H1)<COL UMN(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" a écrit dans le message de news:
...
I am using the following array formula
=MATCH(1,(B10:H10+B15:H15100)*(COLUMN(B1:H1)<COL UMN(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" a écrit dans le message de news:
...
I am using the following array formula
=MATCH(1,(B10:H10+B15:H15100)*(COLUMN(B1:H1)<COL UMN(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:H15100),0)-1

--

HTH

Bob Phillips

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

"Ardus Petus" wrote in message
...
My previous post does not answer your 2nd question.

Cheers,
--
AP

"SJT" a écrit dans le message de news:
...
I am using the following array formula
=MATCH(1,(B10:H10+B15:H15100)*(COLUMN(B1:H1)<COL UMN(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