retrieve data item in terminal cell
 

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

retrieve data item in terminal cell
 

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

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