D
Dave F
Given the range H5:S5, how can I have Excel return the cell address of
the first value that appears in that range.
=MATCH(1,--(H5:S5>0),0) entered as an array formula returns 4; this
value is in cell K5. How can I get that cell address returned?
Thanks.
Dave
the first value that appears in that range.
=MATCH(1,--(H5:S5>0),0) entered as an array formula returns 4; this
value is in cell K5. How can I get that cell address returned?
Thanks.
Dave