None array

=INDEX(A1:A9,COUNTIF(A1:A9,0)+1)

the above formula works only the whole bunch of 0s on top rows not in the
between of other the numbers


"Rowland" wrote:

I am looking for a formula to find the first row in a column that
contains any data.I can do it with an array formula
INDEX(rng,MATCH(TRUE,rng0,0)) but was curious if some can do it without
using an array formula,perhaps with LOOKUP