Hi,

Here is an array formula:

=INDEX(A1:A10,MATCH(1,--(A1:A10*10),0))
or
=INDEX(A1:A10,MATCH(TRUE,A1:A10*10,0))

To make it an array you enter it by pressing Shift+Ctr+Enter

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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??