static array

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RobcPettit@yahoo.co.uk - 21 Mar 2006 22:12 GMT

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 to this Message

cholley - 21 Mar 2006 23:37 GMT

Try using the offset function within your average function: e.g., =average
(offset($B$5,$b$1,1,20,1)). Using this example, the trick will be coming up
with a formula for cell B1, but it shouldn't be too hard. Good luck.

>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 to this Message

RobcPettit@yahoo.co.uk - 22 Mar 2006 08:20 GMT

Thanks for your reply, Idont think this will work as the static array
is created in vba.
Regards Robert

Reply to this Message