Finding last entry in column

[Phil]

I have a list of numbers in column J. How do i show the last entry for
column J in cell H1 ? Further numbers will be added to Column J at later
dates and i always want the bottom entry showing in H1.

Thanks

 

[N Harkawat]

if all the entries that are entered on column J have no blanks and entered
one below the other for the last entry on cell H1 type
==OFFSET(A1,COUNTA(J:J)-1,0)

 

[N Harkawat]

Sorry instead of A1 in the formula change it to J1
=OFFSET(J1,COUNTA(J:J)-1,0)

 

[tjtjjtjt]

If your list of numbers starts in J1 and contains no blanks, put this in H1:
=OFFSET($J$1,COUNTA(J:J)-1,0,1,1)

tj

 

[Aladin Akyurek]

In H1 enter:

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

 

[Phil]

Perfect , thanks

Sorry instead of A1 in the formula change it to J1
=OFFSET(J1,COUNTA(J:J)-1,0)