retrieve data item in terminal cell

[bluegospel]

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

 

[Gary''s Student]

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$65535>0),$A$1:$A$65535),$A$65536)

will retreive the value regardless of type.

 

[Ron Rosenfeld]

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