Would this work for you?:

=INDEX(A:A,MATCH(10^10,A:A),1)

It returns the value of the last numeric item in col A.

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=378536