Excel Mini Challenge: Automatically Generate Serial Numbers with SEQUENCE
- excelwizardd
- May 15
- 1 min read
SEQUENCE
If you’re still dragging numbers manually, it’s time to switch.
Today’s challenge teaches you how to:
✅ Generate dynamic S.No
✅ Have the list expand as you add data
✅ Keep your lists clean and future-proof
🧠 The Formula:
=SEQUENCE(COUNTA(B2:B100))
This counts the names and fills that many serials — no updates needed.
🎯 Works beautifully with:
Student rosters
Invoice or order templates
Inventory lists
Post it here : https://chat.whatsapp.com/DQ3Y2xan15zDIw3mTySF5D
📂 Download the Dataset: https://excelwizardd-my.sharepoint.com/:f:/p/contact/EhQ0P__8Zs1IqItHeoJIFroBryrGDEXnI0cTBs6MUMKXqQ?e=QvoptN
🔗 Ready to practice?
Join us: https://linktr.ee/ExcelWizardd
Comments