To return the first number
=INDEX(A1:A10,MIN(IF(A1:A10<"",ROW(A1:A10))))


To return the 1st non zero number
=INDEX(A1:A10,MIN(IF(A1:A10<0,ROW(A1:A10))))

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula}"

If this post helps click Yes
---------------
Jacob Skaria


"Husker87" wrote:

I have a range A1:A10. Im looking for a formula to put in B1 that will
return the first number in my range A1:A10 when searching from top to bottom.
Sometime the first number appears in A1 and sometimes not until A4 with
other numbers in A7 and A8. I only want A4 or the first number. Thoughts??