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
HIS


"ayedeeh" wrote in message
...
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" wrote:

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
HIS


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