Playing with references

[abinayan]

Hi There,

I've got a question on referencing formulas using the dollar sign.

I have a set of data, for example: 1 2 3 4 5 6 7 8 9
I have to average 4 numbers in one cell. and in the next cell, the next four.
i.e. one cell, =avg(1:4) then in the next cell, =avg(5:8).

I have millions of data like this and I need to know how to reference them in the formula since normally when u drag the formula down it calculate consecutively i.e. one cell=avg(1:4) and next cell, =avg(2:5) etc.

Any help would be greatly appreciated guys.

 

[abinayan]

:D :D :D.. you sir! are a genius!! ..
Thank you very much!! This was eating my head for the whole day!!!

Thanks again!

 

[GlennUK]

Ha ha, you certainly sound pleased.

My pleasure.