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

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.


wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1

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