Return last value in column

  • Thread starter Thread starter Jack Rabbitt
  • Start date Start date
J

Jack Rabbitt

Hi All,

Probably a really silly question, but is there a formula i can use to return
the last entered value at the bottom of a column?

i.e

If say if my data went from A10 to A1000, and A1000 was 12, how do i get A1
to = 12?
Next week A1 would then = A1001 and so on,

Is there a =end of A:A ?

Thanks
 
Put this in A1:

=LOOKUP(10E10,A2:A2000)

will return the last used value in the range A2:A2000.

Hope this helps.

Pete
 
Cheers, that works!


Put this in A1:

=LOOKUP(10E10,A2:A2000)

will return the last used value in the range A2:A2000.

Hope this helps.

Pete
 
Back
Top