Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Moving week numbers
I have a sheet with c1:f1 and h1:k1 with week 29 to week 36, the data for
these weeks are in c5:f5 and h5:k5, this is also with a running total, which will show in chart form.My question is that suppose i have entered data for week 29,30 and 31 what formula will show that the running total is through week 31 and then when i input week 32 the total will show through week 32, this is because the people inputing the data will not place a week number in manually if i set it up that way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
user defined function | Excel Worksheet Functions | |||
Transpose week numbers to date | Excel Discussion (Misc queries) | |||
Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
finding common numbers in large lists | Excel Worksheet Functions |