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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
display last entry into a cell automatically 2
Return last and second last "populated" cell in column 3
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top