I have a spreadsheet with 3 points of data.
I need to take the number per week starting at week one then for week 2, 3, etc use the same number until the total number has been used. I have attached an example to show what I am talking about. Thanks in advanced
View best response
The first step is to link the Week1 cell to the Number to subtract per week using this formula:
The second step, use this formula in Week2 and drag it to the right: