need help to get average value by combining 4 data periodically

[deche]

Sorry for repost my thread. My first thread was made using my android and i cant remove the 'solved' text. So i decided to make another one.

This time i want to remove noise from my thousands data by get their average value from combining 4 data
For example, i have all of my data on column A. And i want to put the result on col B.
In col B1 , i want to put formula like =average(A1:A4)
In col B2 = average(A3:A6)
In col B3 = average(A5:A8) .. etc
But then when i select all of the three row above and drag it into some col to copy it, the formula turn into a mess. I have try to find any other formula, but still i cant solve them.
Could you please help me to solve my problem ? Using formula maybe? Any idea will be appreciated


Finally this thread has been solved for real.

[BB1972]

deche, welcome to the forum.

Duplicate posting is against the forum rules: http://www.excelforum.com/forum-rule...rum-rules.html - rather than re-posting, you should continue in your original post.

DUPLICATE HERE: http://www.excelforum.com/excel-form...51#post3161351

[popipipo]

Try this one:

Please Login or Register  to view this content.

[tgsekhar]

Try with this forumula

Please Login or Register  to view this content.

[daddylonglegs]

I'd use OFFSET like this in B1 copied down

=AVERAGE(OFFSET(A$1,(ROWS(B$1:B1)-1)*2,0,4))

[deche]

deche, welcome to the forum.

Duplicate posting is against the forum rules: http://www.excelforum.com/forum-rule...rum-rules.html - rather than re-posting, you should continue in your original post.

DUPLICATE HERE: http://www.excelforum.com/excel-form...51#post3161351

Hi there. Thanks for your advice. I'll remember it and do the right step on my next thread.

Try with this forumula

Please Login or Register  to view this content.

Hey it works. Big thanks for your help