Average

[vmanp]

hello

I am new to this group.

I am having a large data set which has 1- 6 columns and each column
has 1440 rows. Now I need to average valuesin 1-15 rows and then 16
-30 and so on. Then put the data in a new column. Since I have a large
data I would like to know is any way to automate the process.

waiting for reply

vmanp

 

[Earl Kiosterud]

vmanp,

Put this in a cell in row 1, and copy down with the Fill Handle for each
group of 15 rows.

=AVERAGE(OFFSET($A$1,(ROW()-1)*15,0,15,6))

 

[Ron Rosenfeld]

hello

I am new to this group.

I am having a large data set which has 1- 6 columns and each column
has 1440 rows. Now I need to average valuesin 1-15 rows and then 16
-30 and so on. Then put the data in a new column. Since I have a large
data I would like to know is any way to automate the process.

waiting for reply

vmanp

Assume your table is in A1:F1441 (with the top row being labels, so the data is
in A2:F1441) and you have NAME'd that range: tbl.

In some cell put the number 1

H2: 1
H3: =H1+15

copy/drag down to H97 (which should show 1426)

I2: =AVERAGE(OFFSET(tbl,H2,,15,6))

copy/drag down to I97


--ron

 

[RagDyer]

Try this for a non-volatile approach:

=AVERAGE(INDEX(A:A,15*ROW(1:1)-14):INDEX(A:A,15*ROW(1:1)))

And copy down as needed.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================