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...