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

Thanks! It worked.
Highlighted

@joelmellin , you are welcome

Related Conversations
Autofill Options not available
sailho in Excel on
3 Replies
Feature Request: Add Delete option to Downloads
Eric Hebert in Discussions on
4 Replies
Fill data from a barcode into a system
JKeyfayettevillear in PowerApps & Flow on
1 Replies