Last cell in a range

@

@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.
 
G

Gord Dibben

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
 
@

@Homeonthecouch

Dear Gord

Well that worked a treat !

As always many thanks for your help.

Andrew
 
Top