Autofill using formula

Copper Contributor

Hi! How can I automatically fill the cells using a formula so it can give me continuous numbers? Ex. *100-01* for it to continue with 02,03,04,05 exc.


1 Reply

Hello @Damaris500,

I do not know for sure if I got your question correctly. Try the following:



If it is not what you required, let me know. I also attach sample file with the formula itself. It is a dynamic array formula so you won't be ale to use it inside of an Excel table. It is one downside of this solution.