bdl004
07-15-2010, 06:11 AM
Hi Everybody,
I am having a problem averaging certain sections of an array in VBA. What I have is an array of around 50,000 numerical entries. I need to take the average of the first ten, second ten, third ten... etc. and store this number in a new array. I would prefer to do this without using too many nested loops however I won't disregard this option. Any thoughts on how to approach this?
Thanks a lot, I appreciate any and all help!
I am having a problem averaging certain sections of an array in VBA. What I have is an array of around 50,000 numerical entries. I need to take the average of the first ten, second ten, third ten... etc. and store this number in a new array. I would prefer to do this without using too many nested loops however I won't disregard this option. Any thoughts on how to approach this?
Thanks a lot, I appreciate any and all help!