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
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
[email protected]HIS
"ayedeeh" <[email protected]> wrote in message
news:[email protected]...
>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
> [email protected]HIS
>
>
> "ayedeeh" <[email protected]> wrote in message
> news:[email protected]...
> >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
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
[email protected]HIS
"ayedeeh" <[email protected]> wrote in message
news:[email protected]...
> 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
>> [email protected]HIS
>>
>>
>> "ayedeeh" <[email protected]> wrote in message
>> news:[email protected]...
>> >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
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks