Home

Autofill options

joelmellin
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

@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

 

@Sergei Baklan 

 

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

 

Untitled.png

@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.

@joelmellin , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies