How to make variable range of cells?

Posted by Ertai on Super User See other posts from Super User or by Ertai
Published on 2011-06-21T12:39:26Z Indexed on 2011/06/22 0:25 UTC
Read the original article Hit count: 197

Filed under:
|

In A column I have a set of numbers (over 1 000). I want to get average of ten of them (a1:a10) and wrtite into next column (B). Now I want to get next ten numbers and get average of them (a11:a20). And so on...

How to get this if in C1 i would have number which is range (i.e 10 = a1:a10/a11:a20 ; i.e 25 a1:a25/a26:a50) of the cells? When I change C1 value I want to column B to update automaticaly?

Is this possible?

© Super User or respective owner

Related posts about microsoft-excel

Related posts about vba