On Sun, 7 Jun 2009 11:19:01 -0700, bluegospel .(nospam)
wrote:

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

For the last entry (most rightward) in a row:

=LOOKUP(2,1/(LEN(2:2)0),2:2)

For the last entry (most downward) in a column:

=LOOKUP(2,1/(LEN(A:A)0),A:A)

For versions of Excel prior to Excel 2007, you may not be able to refer to an
entire column. So use this instead:

=LOOKUP(2,1/(LEN(A1:A65535)0),A1:A65535)

--ron