Regarding: =INDEX(A:A,MATCH(10^99,A:A))
The 10^99 simply creates an impossibly large number to be used in the
worksheet (Excel can only handle values with up to 15 digits).
When the MATCH function does not find a match, it returns the position
of the last numeric value.
Side note:
As has been posted, a better way to return the last numeric value in a
column is:
=LOOKUP(10^10,H:H)
I hope that helps.
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=521186