can excel find the last used line in a column and display it?
 

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

Paul,

This won't select it, only a macro could do that, but this formula will
display the last cell. There can be no empty cells along the way.

=OFFSET(A1,COUNTA(A:A)-1,0,1,1)

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Paul - South Australia" <Paul - South
wrote in message ...
With a column of data I want to automatically select the last line and
display it in another cell, possible?

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?