hi
I have months in rows and names in columns. apr to sep achievement last and apr to aug achievement this year. now i want to give a target for september so that the year till date (YTD sep) growth will be 5% more than YTD Growth of aug. I am unable to find a formula. please help
<colgroup><col span="7"><col><col span="6"><col><col><col></colgroup><tbody>
</tbody>
I have months in rows and names in columns. apr to sep achievement last and apr to aug achievement this year. now i want to give a target for september so that the year till date (YTD sep) growth will be 5% more than YTD Growth of aug. I am unable to find a formula. please help
Names | Apr'13 | May'13 | June'13 | July,13 | Aug'13 | Sep'13 | Total | Apr'14 | May'14 | June'14 | July,14 | Aug'14 | Sep'14 | Total | YTD Aug Gr | YTD Sep Gr |
A | 1 | 5 | 8 | 5 | 8 | 7 | 34 | 5 | 8 | 7 | 1 | 5 | 26 | -4% | -24% | |
B | 2 | 5 | 1 | 4 | 1 | 5 | 18 | 4 | 1 | 5 | 2 | 5 | 17 | 31% | -6% | |
C | 5 | 8 | 2 | 3 | 2 | 8 | 28 | 3 | 2 | 8 | 5 | 8 | 26 | 30% | -7% | |
D | 4 | 5 | 4 | 5 | 4 | 5 | 27 | 5 | 4 | 5 | 4 | 5 | 23 | 5% | -15% | |
E | 5 | 8 | 5 | 1 | 5 | 8 | 32 | 1 | 5 | 8 | 5 | 8 | 27 | 13% | -16% | |
F | 6 | 7 | 6 | 12 | 6 | 7 | 44 | 12 | 6 | 7 | 6 | 7 | 38 | 3% | -14% | |
G | 7 | 2 | 8 | 2 | 8 | 2 | 29 | 2 | 8 | 2 | 7 | 2 | 21 | -22% | -28% | |
H | 8 | 7 | 4 | 4 | 4 | 7 | 34 | 4 | 4 | 7 | 8 | 7 | 30 | 11% | -12% |
<colgroup><col span="7"><col><col span="6"><col><col><col></colgroup><tbody>
</tbody>