CODEWITHSUNDEEP
excelcell
Ridwan Sanusi
Ridwan Sanusi

Reputation: 3

Formular dragging in Excel

I have a data of 1000 rows in Excel, and I wish to calculate the variance of every 10 data, say =var.s(A1:A10), =var.s(A11:A20), .....
I did the first two manually and tried to drag the formulas down, but instead of having =var.s(A21:A30), =var.s(A31:A40) I had =var.s(A3:A12), =var.s(A13:A22).

Could anyone please suggest how I can get my desired results?

Upvotes: 0

Views: 55

Answers (1)

Tim Williams
Tim Williams

Reputation: 166256

If your values are in ColA you can use a formula like the one shown below: for each row you drag it down it will offset the range fed to VAR.S by 10 rows.

enter image description here

Upvotes: 1

Related Questions