calvinbiss
Golden Member
I have 8445 data points for which I need to average every 15 data points. I would like these averages to to displayed in the adjacent column in an array that is 563 rows high by 1 col wide.
As a simple example, lets say I have 20 data points in a single column that live in column A, rows 1-20. I want the average of every 2 data points (going down the column) displayed in column B, rows 1-10.
Edit: I found this answer: http://www.mrexcel.com/forum/showthread.php?t=59400
But when I copy the formula given in the link down the column, I get the same repeating value of the first average.
Frustrated!!!
As a simple example, lets say I have 20 data points in a single column that live in column A, rows 1-20. I want the average of every 2 data points (going down the column) displayed in column B, rows 1-10.
Edit: I found this answer: http://www.mrexcel.com/forum/showthread.php?t=59400
But when I copy the formula given in the link down the column, I get the same repeating value of the first average.
Frustrated!!!
Last edited:
