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
[TABLE="width: 128"]
<tbody>[TR]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 192"]
<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]1
[/TD]
[TD="width: 64, align: right"]3[/TD]
[TD="width: 64"]=AVERAGE(A1:A5)
[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]8[/TD]
[TD]=AVERAGE(A6:A10)
[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]13[/TD]
[TD]=AVERAGE(A11:A15)
[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]18[/TD]
[TD]=AVERAGE(A16:A20)
[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thank you!

 

[Andrew Poulsom]

Welcome to MrExcel.

One way:

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