display last entry in Excel

[ayedeeh]

I have created a column that calculates the running total, and i would like
Excel to use only the last value in the list. however, when a new value is
added to the bottom of the list, excel will then take that entry.

Can anybody help. Thanks

 

[Nick Hodge]

Ayedeeh

If the data is contiguous, (say in column A), you could use this

=INDIRECT("A"&COUNTA(A:A))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[ayedeeh]

What if the list is not continuous, or if i display "zero values", can i get
it to display the last entry greater than 1?

 

[Nick Hodge]

ayedeeh

I used contiguous, not continuous, that is, there is no gaps in the data.
0's work fine

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)