View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pivot table pivot table is offline
external usenet poster
 
Posts: 7
Default Monthly Percent Increase

Say I have the data listed below:

January - 250
February -275
March - 350
April - 400
May - 500
June - 650
July - 1000
August -1250
September -1600
October - 2000
November - 2600
December - 2750

Here is the formula I used:

=(February/January)-1

Once all the months are done then average all the percents together to get a
monthly percent increase average...

I want to get monthly percent increase then get an average monthly percent
increase of all months.

Please advise the easiest way to do this and what the formula would be.

Thanks,
nolanstern