TYPO - must equalize the ranges!

=INDEX(A1:A10,MATCH(1,INDEX((ISNUMBER(A1:A10))*(A1 :A100),),))

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
Besides bypassing text, why not add the other alternative of *also*
bypassing zeroes:

=INDEX(A1:A20,MATCH(1,INDEX((ISNUMBER(A1:A20))*(A1 :A100),),))

--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-

"Harlan Grove" wrote in message
...
"T. Valko" wrote...
Try this array formula** :

=INDEX(A1:A10,MATCH(TRUE,ISNUMBER(A1:A10),0))
...

Could avoid array entry with

=INDEX(A1:A20,MATCH(TRUE,INDEX(ISNUMBER(A1:A20),0) ,0))