How to know on which row a value ceases to be zero

[WelshGareth]

Hi,

There are two relevant columns in a table of thousands. The first has the row count, the cells in the second are zero until a long way down the table when they start containing higher numbers.

At the moment, I have to scroll down until I see a number other than zero to see on which row this happened.

What I'd like is a cell to tell me on which row the value first ceases to be zero. Can anyone think of a way of doing this please?

Gareth

 

[erik.van.geit]

of course, Peter_SSs,
but we assumed that sometimes there could be no "0" within the range

best regards,
Erik

 

[Peter_SSs]

but we assumed that sometimes there could be no "0" within the range

Fair enough Erik, but I was just going with the original post that said there were lots of 0s before any other values.

If it was possible that no 0s occurred at the start, then the answer would be 1 (example data started in row 1), so I would just use:
=IF(A1<>0,1,MATCH(0,A:A,1)+1)

 

[erik.van.geit]

but I was just going with the original post that said there were lots of 0s before any other values

of course you're right, but we know that the unexpected exceptions occur when we didn't foresee them