| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel | |||
| How do I display a data table in an Excel 2002 chart? | Charts and Charting in Excel | |||
| Axis display as category | Charts and Charting in Excel | |||
| How do I get the trendline equation from Excel to script? | Charts and Charting in Excel | |||
| Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Linear Mode
