Data Reduction

[tonyse]

I have recieved some data from an experiement with around 10,000 data points. I am wondering how to take the average of every 5 numbers so that the data is reduced Theres got to be an easy way.

For example i want

<tbody>
</tbody>

1	3	=AVERAGE(A1:A5)
2	8	=AVERAGE(A6:A10)
3	13	=AVERAGE(A11:A15)
4	18	=AVERAGE(A16:A20)
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody>
</tbody>

Thank you!

 

[Andrew Poulsom]

Welcome to MrExcel.

One way:

=AVERAGE(OFFSET(A$1,(ROWS(A$1:A1)-ROW(A$1))*5,0,5))