retrieve data item in terminal cell
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
|