If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Rolling figure to a cell
I am trying to calculate a rolling figure to a cell by updating a spread
sheet on a weekly basis. I want to input data on a dated row and get the formula to take this away from the previous dated reading and calculate to a single cell. -- Brenton |
#2
|
|||
|
|||
Rolling figure to a cell
Hi,
Your question is not clear. Please post an example as well -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Brenton" wrote in message ... I am trying to calculate a rolling figure to a cell by updating a spread sheet on a weekly basis. I want to input data on a dated row and get the formula to take this away from the previous dated reading and calculate to a single cell. -- Brenton |
#3
|
|||
|
|||
Rolling figure to a cell
Date Previous week This week
Hours Set #1 2940 2940 Set #2 1936 2049 Set #3 2082 2130 Set #4 1908 1976 Kw Set #1 1361.762 1361.765 Set #2 1930.406 2019.982 Set #3 2085.238 2124.608 Set #4 1849.138 1901.259 Aux Set #1 26.188 26.191 Set #2 42.732 44.997 Set #3 46.057 47.037 Set #4 36.807 37.702 Fuel Set #1 340.899 340.937 Set #2 485.473 508.251 Set #3 520.235 530.011 Set #4 465.814 479.745 Hours Set#1 0 Set#2 113 Set#3 48 Set#4 68 -- Brenton "Ashish Mathur" wrote: Hi, Your question is not clear. Please post an example as well -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Brenton" wrote in message ... I am trying to calculate a rolling figure to a cell by updating a spread sheet on a weekly basis. I want to input data on a dated row and get the formula to take this away from the previous dated reading and calculate to a single cell. -- Brenton |
Thread Tools | |
Display Modes | |
|
|