display last entry in Excel
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 |
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 |
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 |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com