Hallo everyone,
I have 6000 data points, which is too much. The data points are aligned with
a time line. It measures 10 times a second. I want to take the average of
each second (so ten data points) how do I do that?

I can't do it manually and if I use the average function it averages the
first 10 and then 2-11 while it should average 10-20 and so on.

Please help, Thank you.

Hi Vikash,

I'm sure this can be tidied up, but, one way, is with
your data in A1:A6000.

In B10 put =AVERAGE(A1:A10)
Then highlight B1 to B10
Grab the fill handle and drag to the end of your data
Then use autofilter to compact column B and then copy it
to somewhere usable.

HTH
Martin

Vikash เขียน:
Hallo everyone,
I have 6000 data points, which is too much. The data points are aligned with
a time line. It measures 10 times a second. I want to take the average of
each second (so ten data points) how do I do that?

I can't do it manually and if I use the average function it averages the
first 10 and then 2-11 while it should average 10-20 and so on.

Please help, Thank you.

If A2:A6000 contain your data.

B2

=SUMPRODUCT(SUBTOTAL(1,OFFSET($A$2,10*(ROWS($A$2:A 2)-1),0,10,1)))

Copy down.

If B1 is represent number of next 10 cells (1 -- 1-10, 2 --
11-20...) that can manual change the number what you want and show
result in B2 only.

=SUMPRODUCT(SUBTOTAL(1,OFFSET($A$2,10*(B1-1),0,10,1)))