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. |
All times are GMT +1. The time now is 06:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com