Measuring growth?

[thorpyuk]

Hi All

I've several columns of sales data that i'd like to analyse and look for which has the highest rate of growth...


Obviously, i could concoct something myself, but is there any function i could use in excel already?

Thanks!

 

[MickG]

If "P" is the Value at the start of the number of periods, and "Sp" is the Value at the end, then if "n" is the number of periods and the percentage return = "r" ,then:-

 r = [(Sp/P)^(1/n)]-1

So "P" would = your first value , "Sp" the last and "n" the number of "Weeks" "Months" or years your working with.
Mick