Thread
:
display last entry in Excel
View Single Post
#
2
Nick Hodge
Posts: n/a
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
Reply With Quote