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