Last Value in Column

[Chris Bezant]

Hello Learned People

Can anyone tell me if there is a way of entering a
formula in a cell that will display the latest value from
that column?

I have a column containing a running total of a bank
account, say, and I want to pass that latest total to
another sheet. The problem is that the latest value is in
a different cell each time I add a new row with the next
transaction. I thought the best way to do that would be
to have a cell at the bottom of the column which picked
up the value from the last cell above it that contains a
value. Another sheet can then reference that cell at the
bottom of the column. Hope that makes sense.

Thanks for any help
Chris Bezant

 

[Peo Sjoblom]

Assuming there are no blanks in-between

=INDEX(A:A,COUNTA(A:A))

adapt to fit your own ranges

 

[ivano]

sorry, thank you very much Aladin.