Home

Autofill options

Highlighted
New Contributor

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
Highlighted

@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

 

Highlighted

@Sergei Baklan 

 

It does not work, it says it is wrong in the formula.

 

Untitled.png

Highlighted

@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

Highlighted
Thanks! It worked.
Highlighted

@joelmellin , you are welcome

Related Conversations