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)

"Phil" wrote in message
...
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