Excel: Streamline Your Workflow: Auto-Generate an ID Number When New Row is Populated

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

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?

🙋‍♂️ Let's connect on social

#excel #autonumber #sequence

[QBOY]

I watched so many complicated videos trying to do this and was getting annoyed. But Mike I found this video and was great, you explained it well and easy to follow and understand. Thank You soo much 👏

[eduardsalazar]

very simple yet extremely helpful. thanks a lot

[brianchittum]

Just what I was looking for and explained perfectly. Thank you

[rudy]

Hi Mike. This is crispy clear. However, once you generate the “ticket ## and you sort the column ( name for example), it will loose the order this the ticket number. Any simple walk around to link the assigned ticket to the name or row/ cell?? thank you in advance

[elp]

Amazing. Thank you! I was trying to build out the steps to creating dependencies in a gantt and this helps a lot!

[b-man]

Great workaround for those not on 365. Worked a treat!

[pandamonium]

I am learning sooo much from your lovely short videos 🐼🐼🐼🐼

[pandamonium]

Presume Lola bear had put in a support call for treats or walkies

[kunalrules]

I really loved your video. I have a follow-up question. What if I want to lock the ID value.
For example, it runs totally fine until I add a new row in between already generated ID's. As it is working on -2 or -3 principal (Removing the header lines) the ID value also changes of already generated ID's when any row is added not at the end but in the middle. So I want to lock this value, i hope i make sense.

[ZoltanMabat]

Hi Mike. I just found your channel. Awesome videos! I would like to be able to begin the sequence with a number of my choosing. Is there a way to specify the starting value (after the text portion) for the serial number?

[dzonison]

Thanks Mike!
Great video! Gould you please tell me if I want to add additional text after the numbers in formula e.g TET-00011-HH-GG, how can I do it?

[josephplacek]

How can I keep the serial number from changing if a row is added above any given row? I want my customer ID to be fixed to a customer to be able to link them to another table.

[robinsonrodrigues]

First of all amazing Tshirt Sr Thomas!!!
Please instead of all add TET in ID number invert the three first letter from first name?

[rafvanhellemont]

i did the formula =IF(B4="", "", ROW()-4) but it is not working

[josephgfernandez]

Hi Mike, how do you integrate form field from my website to an Excel Sheet ?