You have a few options:
1. The value of the last non-blank in Col_A:
=INDEX(A1:A65535,MATCH(2,1/(1-ISBLANK(A1:A65535))))
Note: Commit that array formula by holding down the [Ctrl][Shift] keys
and press [Enter].
2. The value of the last numeric value in Col_A:
=INDEX(A:A,MATCH(10^99,A:A))
3. The value of the last text value in Col_A:
=INDEX(A:A,MATCH(REPT("z",255),A:A))
Does that give you something to work with?
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