In H1 enter:

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

Phil wrote:
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