Posted to microsoft.public.excel.worksheet.functions

Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline

external usenet poster

Posts: 896

Average Monthly Growth rate

would this help?

=(OFFSET($A$5,,COUNTA($A$5:$I$5)-1)-$A$5)/(OFFSET($A
$5,,ILE.NIEPUSTYCH($A$5:$I$5)-1)*(COUNTA($A$5:$I$5)-COLUMN($A$5)))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Average Growth Rate	scott	Excel Discussion (Misc queries)	8	October 26th 06 12:01 AM
Growth Rate	Native	Excel Discussion (Misc queries)	2	September 21st 06 12:34 AM
growth rate but not average	kotlon	Excel Discussion (Misc queries)	1	June 19th 06 11:09 AM
annual growth rate from monthly data	kotlon	Excel Discussion (Misc queries)	4	June 16th 06 08:56 PM
monthly growth rate	my	Excel Worksheet Functions	5	March 2nd 06 01:07 AM

All times are GMT +1. The time now is 04:23 PM.

About Us

"It's about Microsoft Excel"