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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
try where the 0 is found in row 18
=INDEX(17:18,1,MATCH(0,18:18,0))
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First row where a cell is zero 1
Counting Zeros in a row until encounter first non-zero value 9
Excel: Last non zero value in a row 4
Last non-zero 5
Compare identifier columns from 2 sheets - remove rows that are dups 2
LOOKUP across a whole table and not just first row or column 4
Excel Use COUNTIF across a range of cells with formulas 0
count the number of rows with entries greater than zero 1

Back
Top