static array

  • Thread starter Thread starter RobcPettit
  • Start date Start date
R

RobcPettit

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.
 
Thanks for your reply, Idont think this will work as the static array
is created in vba.
Regards Robert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

array revisited 2
vArray = Sheet2.Range("A1:A" & lr) troubles ahoy 11
averaging arrays 2
Average row of Data using VBA 5
print values in an array 2
recalculating RAND() inside a VBA loop 5
Six columns randon no.'s no dupes 6
Time averaging raw data 3

Back
Top