If the last value in column A is a number than:

=LOOKUP(99^99,A:A)

will retreive its value

the more complex formula:

=IF(ISBLANK($A$65536),LOOKUP(2,1/($A$1:$A$655350),$A$1:$A$65535),$A$65536)

will retreive the value regardless of type.
--
Gary''s Student - gsnu200856


"bluegospel" wrote:

Is there an easy way to retrieve the data item or value in the terminal cell
of a column or row?
--
Barth "John" Jones