Forum Discussion
Autofill options
Hi!
I want to automatically create the following:
=VARIANS(M9:M20)
=VARIANS(M21:M32)
=VARIANS(M33:44)
...
...
...
VARIANS(M463:M474)
Could I do this easily with autofill somehow?
6 Replies
joelmellin , if you start your formulas from A2 down, in English notation it could be like
=VAR(INDEX(M:M,9+(ROW()-ROW($A$2))*12):INDEX(M:M,20+(ROW()-ROW($A$2))*12))
and drag it down
joelmellin , I guess in your locale it shall be another functions names and maybe semicolon as separator. Please open attached file, formula shall be shown as in your locale
