how to find the average from a group of data

[runbird]

hi all,

i have a set of 900 data and i wish to find the average from every 30 data, is there a way to do it?

e.g average 1 is from data 1-30,

average 2 is from data 31 to 60....

average 30 is from data 871 to 900....


thank you

 

[JoeMo]

If you data are in col A starting in cell A1, enter this formula in B1 and drag down to your last data point.

=IF(MOD(ROW(),30)=0,AVERAGE(OFFSET(A1,-29,0,30)),"")

 

[runbird]

If you data are in col A starting in cell A1, enter this formula in B1 and drag down to your last data point.

=IF(MOD(ROW(),30)=0,AVERAGE(OFFSET(A1,-29,0,30)),"")

hi joe,

thanks for the code. i am able to get the average of the data, but the average is space 30 rows apart. is it possible to group the average together so that it will be more easier to copy them?

thanks

 

[JoeMo]

Filter column B for non-blank cells to group them. In the filter criteria dialog box choose text filter>does not equal and leave the criteria empty.

EDIT: If you prefer here's another way to group the averages:

Excel Workbook
	C	D
1	Row	Avg_30
2	30	1
3	60	1
4	90	1.3
Sheet1