In this advanced Google Sheets tutorial, we take automatic number sequencing to the next level! Learn how to create a dynamic number sequence that resets for each category (like VIP, Frequent, New, Abandoned, etc.) using powerful formulas such as ARRAYFORMULA, QUERY, SEQUENCE, VLOOKUP, and more. Perfect for customer lists, case tracking, and any scenario where you need unique indexes per group. We’ll break down the step-by-step logic, optimize the formula, and discuss performance tips for large datasets.

You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
https://practicalsheets.com/patreon

You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more

You can also subscribe to the channel where you´ll find a new Sheets video every week.

Here are some of the places where you can follow and support me:
Patreon: https://practicalsheets.com/patreon
Webpage: https://practicalsheets.com
Newsletter: https://practicalsheets.com/newsletter
Telegram: https://practicalsheets.com/telegram
Facebook: https://practicalsheets.com/facebook
Twitter: https://practicalsheets.com/twitter

Any suggestion, question or insights, feel free to comment below