Posted to microsoft.public.excel.programming

[email protected][_2_] RobcPettit@yahoo.co.uk[_2_] is offline

external usenet poster

Posts: 80

static array

Hi, Using a static array, with 100 values. is it possible to average
the last 20 values, and if i add another 20 values, to average agian.
In other words always averge the last 20 values.
Regards Robert

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
meaning of : IF(Switch; Average(array A, array B); array A)	DXAT	Excel Worksheet Functions	1	October 24th 06 06:11 PM
Load a static array at procedure level	XP	Excel Programming	1	March 10th 06 04:27 PM
"Static" Behavior without Static Defn	Steve Drenker[_2_]	Excel Programming	1	March 2nd 06 01:33 AM
Lookup from Static List/Array	Support	Excel Worksheet Functions	2	February 17th 06 06:40 PM
keeping a sum array static	cmattmills	Excel Worksheet Functions	4	February 8th 06 05:45 PM

All times are GMT +1. The time now is 09:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us