Mar 28 2019 03:37 PM
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?
Mar 29 2019 01:43 AM
@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
Mar 29 2019 03:06 AM
Mar 29 2019 03:31 AM
@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