In this video I show you a way to quickly and easily automatically generate sequential numbers down a column (TET-00001, TET-00002 etc). Useful for automatically generating ticketID's, invoice numbers etc.
🗒 Notes and Resources
Download a copy of the file used in this video: app.box.com/s/hupj8nka782yoeh...
The formulas that I used in the demos:
=ROW()
=ROW()-3
=If(B4="","",ROW()-3)
=If(B4="","",TEXT(ROW()-3,"00000"))
=If(B4="","","TET-" & TEXT(ROW()-3,"00000"))
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #autonumber #sequence
Негізгі бет Excel: Streamline Your Workflow: Auto-Generate an ID Number When New Row is Populated
Пікірлер: 14