Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a $figure be converted to words in another cell | Excel Discussion (Misc queries) | |||
how do i overwrite a cell and keep adding to another figure? | New Users to Excel | |||
cell * figure | Excel Discussion (Misc queries) | |||
Cell formating and Rolling columns | Excel Discussion (Misc queries) | |||
Z Chart i.e. top rolling annual bottom rolling monthly middle cum. | Excel Worksheet Functions |