So here's a tricky one. I tried using CAGR but it doesnt seem to work for me... maybe my logic is wrong. Here is what I want to do:
1 have 37 columns, months 0 to 36. month 0 has a number = 220
Totals of values from month 1 to 12 needs to = 41528
Totals of values from month 13 to 24 needs to = 98087
Totals of values from month 25 to 36 needs to = 176970
need to populate all cells with appropriate values
the catch is that the value of month 1 cannot be less than month 0, the value of month 13 cannot be less than month 12, the value of month 25 cannot be less than month 24.
is there any simple way to do this?
thanks guys, it will be greatly appreciated.