Forum Discussion

joelmellin's avatar
joelmellin
Copper Contributor
Mar 28, 2019

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?
Formulas and Functions
joelmellin's avatar
joelmellin
Copper Contributor
Mar 29, 2019

SergeiBaklan 

 

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

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 29, 2019

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

  • joelmellin's avatar
    joelmellin
    Copper Contributor
    Mar 29, 2019
    Thanks! It worked.

Resources