what formula in Excel will identify the first zero in a row and...

D

Dawnstar253

A row contains a series of diminishing numbers. I am looking for a formula
to identify the first zero occuring in the row and return the date contained
in the same column but higher row.
Any help is appreciated.
 
B

Bob Phillips

Here is an example with rows 8 and 9

=INDEX(8:8,,MIN(IF(9:9=0,COLUMN(9:9))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top