Forum Discussion
Autofill using formula
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.
Hello Damaris500,
I do not know for sure if I got your question correctly. Try the following:
=TO.COL(SEQUENCE(1,2,100,1)&"-"&TEXT(SEQUENCE(99,1,1,1),"00"),,1)
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.