Finding last entry in column
 

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

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

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

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

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

"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

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

Perfect , thanks

"N Harkawat" wrote in message
...
Sorry instead of A1 in the formula change it to J1
=OFFSET(J1,COUNTA(J:J)-1,0)

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