Last cell in a range

  • Thread starter Thread starter @Homeonthecouch
  • Start date Start date
@

@Homeonthecouch

Can anyone tell me the way to display the latest entry into a range of cells
in a downward entry
e.g
A1 3
A2 5
A3 6
A4 5


I would like a cell to report the last cell in the column regardless of
whether it is the highest or lowest in the range.

Any help is as always Appreciated.

Andrew.
 
Andrew

Will return the last entry in column A no matter what type of data.

=LOOKUP(2,1/(A1:A65535<>""),A1:A65535)

For Numeric entry only..............

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

For Text entry only....................

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


Gord Dibben MS Excel MVP
 
Dear Gord

Well that worked a treat !

As always many thanks for your help.

Andrew
 
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

Mutiply in a range of cells ? 1
Average Question 2
Last cell data 3
Offset and Small functions with blank rows? 0
VBA set thick borders around non empty cells in range 0
loop until empty row and column problem (format cells until the lastrow and column in a report) 2
Displaying a range based on a cell's contents 3
Blank Cells 3

Back
Top