Return last value in column

[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

 

[Pete_UK]

Put this in A1:

=LOOKUP(10E10,A2:A2000)

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

Hope this helps.

Pete

 

[Jack Rabbitt]

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

 

[Pete_UK]

You're welcome, Jack - thanks for feeding back.

Pete