Autofill options

New Contributor


I want to automatically create the following:









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


and drag it down


@Sergei Baklan 


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



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

@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