Restart Sequential Numbering in Excel When a Value Changes - Auto Reset Numbers in a List

Need Excel to restart sequential numbering when a value changes? This tutorial shows how to restart numbering in Excel automatically using an IF formula, so each time an item recurs, its number will increase by 1, and the numbering will reset to 1 for a new item. You'll learn a simple IF formula trick that automatically resets numbering for each group of records — perfect for employee data, invoices, order items, or database uploads. This video topic can also be described by: - How do I auto number multiple recurring items in Excel - How to make a numbered list in Excel restart the count (start over at 1) whenever the item in an adjacent column changes - Sequential numbering that needs to start over as info in a different column changes - How to give numbers to rows that reset every time the value of another column changes - How to create a sequence number in Excel based on two columns If you're preparing data for an HRIS, CRM, finance system, or any database upload, you often need sequential numbers that restart for each unique record. Instead of manually resetting numbers, this quick Excel formula does it automatically. In this example, you'll see how to number employee skills for each employee ID, with the sequence restarting every time a new employee appears in the spreadsheet. This technique is useful for: • HR employee data uploads • invoice line items • grouped transaction data • order records • database imports • any Excel dataset where numbering must restart by group 📊 What you'll learn in this video ✔ How to restart sequential numbering in Excel automatically ✔ The IF formula that resets numbering when a value changes ✔ How to number rows by group in Excel ✔ A quick tip for preparing Excel data for database uploads #ExcelTips #ExcelTutorial #ExcelFormulas #DataCleaning #ExcelForWork ⏰ TIMESTAMPS 00:00 Restart Numbering Automatically in Excel 00:16 Example: Sequential Numbers by Employee 00:36 Sort Data for Grouping Records 01:12 Create the IF Formula for Sequential Numbering 02:02 Copy the IF Formula Down the Column 02:24 Convert Excel Formulas to Values 🎓 FREE COURSE - How to Create Fillable Forms in Microsoft Word - A Step-by-Step Guide Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro: https: https://youtu.be/438pCPCSuG4 📎 CHANNEL LINK https://www.youtube.com/@SharonSmith Visit my Channel page on YouTube to see all my videos, playlists, community posts and more! 📄 TEMPLATES Check out my helpful list of templates available for purchase: https://creatoriq.cc/43c51cv Thank you for supporting my channel! 🌟 ⬇️ FREE DOWNLOADS ✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals. 👋 CONNECT WITH ME Visit my website: https://www.sharonsmithhr.com for more information, tools and resources. LinkedIn: https://www.linkedin.com/in/sharonsmithhr Twitter: https://twitter.com/SharonSmithHR Instagram: https://www.instagram.com/sharonsmithlearning/ Facebook: https://www.facebook.com/SharonSmithLearning ⚙️ GEAR 🎙 Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!) 🖱 Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!) 🎥 Screen Recording Software: https://techsmith.z6rjha.net/NZG5b 📗 Green Screen: https://amzn.to/2DnHsY2 📸 Camera: https://amzn.to/39KvpQA 🔌 Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top notch webcam) 📚 RESOURCES ✏️ JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog 🖥️ TechSmith Camtasia Screen Recording: https://techsmith.z6rjha.net/SharonSmithHR Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel! 🙌 SUPPORT THIS CHANNEL - Hit the "$Thanks" button on any video, or - Donate through my PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills. You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much! ❤️ 🎥 PLAYLISTS ➤ Excel Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90 ➤ Excel Tips & Tricks: https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW