Lookup formula

R

Rowland

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,rng>0,0)) but was curious if some can do it without
using an array formula,perhaps with LOOKUP
 
B

Bernard Liengme

I expect there is something more elegant but I came up with this
=INDEX(A1:A7,SUMPRODUCT(MIN((A1:A7<>"")*ROW(A1:A7)+(A1:A7="")*9999999)))
best wishes
 
G

Guest

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
 

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

Cell value using Max 3
Retrieve the Nth element in a dataset 6
finding n-th most frequently occuring word 4
Vlookup and return sheet name also 2
vlookup and match first value greater than 4
Scrabble Value calculation for Welsh words 0
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) 1
Index Match on Columns and Rows 0

Top