Hi Jarek,
thanks yes that works, but I'm actually trying to do it all in one row such
that the second row is not necessary. Surely there is a formula that will do
this - it is quite similar to IRR or RATE, does anyone know?
Regards.


"Jarek Kujawa" wrote:

presuming yr data (=9,203) starts in A1 with the use of the following
formula:

=(B5-$A$5)/(B5*COLUMN(B5)-COLUMN($A$5))

i achieved the following results for the AVERAGE MONTHLY growth rate

9203 9520 8078 8744 8070
1,67% -4,64% -1,31% -2,81%