Rolling average formula

[T15K]

I have the following problem, I would be grateful for any solutions...

In column A, I have about 15000 rows worth of values, and what I need is a rolling the average of each 5 rows to appear in column B.

For example;
in cell B1, I need the average of A1-A5
in cell B2, average A2-A6
in cell B3, average of A3-A7
in cell B4, average of A4-A8

And so on until each all of column A is averaged (in 5 row blocks, moving one row down each time) into col B.

I thank you in advance for any assistance provided....

[Fotis1991]

=average(offset($a$1:$a$15000,(rows(a$1:a1)-1)*5,,5))

[T15K]

Thanks for your assistance however, this is not quite what I am after.
This offset formula appears to give the average of A1-A5, then A6-A10, A11-A15 etc
What I need is A1-A5, then A2-A6, then A3-A7 etc

Is this possible?

[Fotis1991]

Then you need just.. =AVERAGE(A1:A5)

In B1 and copy down..

[T15K]

I apologise, but in providing the example I simplified the problem a bit too much and so the most recent solution is still not quite what I am after.

I will now post the complete problem and hopefully this will be able to help you solve my problem

Again, there are 15000 rows of data in starting in A1
in B1, I would like the average of the A1 to A1500
in B2, I would like the average of A301 to A1800
in B3, I would like the average of A601 to A2100
in B4, I would like the average of A901 to A2400

and so on until up until A15000

Another way of saying it is that I need the average of 1500 rows, and each time the average moved 300 rows down the data list.

Again, I thank you in advance for your perseverence

[Pepe Le Mokko]

Perhaps

Please Login or Register  to view this content.

entered in B1 and pulled down as needed

[T15K]

That appears to have done the trick - many thanks.