Array Formula w/ COLUMN & MATCH FUNCTIONS

S

SJT

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
 
A

Ardus Petus

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

HTH
 
S

SJT

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

Bob Phillips

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)
 
Top