Paul

To display the last numeric in a column........

=LOOKUP(9.99999999999999E+307,A:A)

To display the last text entry in a column..........

=LOOKUP(REPT("z",255),A:A)

Both will ignore blank cells.


Gord Dibben Excel MVP


On Mon, 14 Mar 2005 20:01:02 -0800, "Paul - South Australia" <Paul - South
wrote:

With a column of data I want to automatically select the last line and
display it in another cell, possible?