Array Formula w/ COLUMN & MATCH FUNCTIONS
 

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

Array Formula w/ COLUMN & MATCH FUNCTIONS
 

=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

Array Formula w/ COLUMN & MATCH FUNCTIONS
 

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

Array Formula w/ COLUMN & MATCH FUNCTIONS
 

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

Array Formula w/ COLUMN & MATCH FUNCTIONS
 

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