Hi all, new member here. Pleasure to meet you.
I'm trying to find a formula which could help me evenly redistribute numbers in remaining columns from other columns.
I've made a ''goal'' column, a ''As per today'' column and ''remaining'' column. Per example, I have a 200 000 goal for 10 weeks. 1st week I've made 5 000, so the ''as per today'' column should show 5 000, and the remaining column 195 000.
Now, I want the 195 000 to be evenly redistributed for the 9 remaining weeks. So basically, I have per say a 10 cell area (weeks). Each monday, I have to enter REAL numbers. So if I've made 5 000 the first week, the remaining 195 000 should be redistributed in the 9 other weeks, so a 21 666 goal per week (195 000/9).
**Not every line will last exactly 10 weeks, begin on week 1 and finish on week 10**.
And if I made a real 10 000 on the week 2, the remaining 185 000 should be redistributed in the next 8 weeks, so a 23 125 goal per week (185 000/8). So my 10 cell area is affected by 2 formulas. And that also, I'm not so sure how to handle this.
Test master sales.PNG
Can someone help me with that? I've attached the excel doc for you guys to see/test.
Thanks for your help, really appreciated!
JP
Bookmarks