I have the following problem, I would be grateful for any solutions...
In column A, I have about 15000 rows worth of values, and what I need is the average of each 5 rows to appear in column B.
For example;
in cell B1, I need the average of A1-A5
in cell B2, average A6-A10
in cell B3, average of A11-A15
in cell B4, average of A16-20
And so on until each all of column A is averaged (in 5 row blocks) into col B.
I thank you in advance for any assistance provided....
Bookmarks