Dynamic Category Sequencing Formula -- 2

@harshitak464

Hello! I’d be happy to assist with building a stable, dynamic ID formula that generates numbering in the format [sequence]/[total in category], fully resilient to sorting, inserting rows, and adding new categories. I understand the behaviour you’re after: The sequence must reset to 1 whenever the category in Column A changes. The denominator must always show the total count of that category, no matter how the sheet is sorted. The logic must adapt automatically to 6–10 changing categories and new rows. Stability must be guaranteed, ideally through formulas compatible with Microsoft 365, but I can also provide a minimal VBA fallback if needed. I have strong experience building structured, dynamic Excel systems using COUNTIFS, LET, UNIQUE, SCAN, FILTER, SEQUENCE, and other modern functions. I ensure that the formulas remain clean, reusable, and robust even as data grows or is rearranged. What I will deliver: A single formula you can drop into your sheet, producing “[sequence]/[total]” for every row A short, clear explanation of how the logic works A test sheet or simple instructions so you can verify instantly Optional lightweight VBA helper if required for perfect stability I can start right away and provide a fully working, easy-to-maintain solution. Looking forward to assisting you!

@deven9096

I combine the precision of a specialist with the range of a generalist, all delivered with unmatched speed and structure tailored specifically for you.

@kumar0145

Experienced Excel specialist skilled in creating dynamic category sequencing formulas for seamless data management.

@atharva113

I'm confident I can deliver a compelling pitch deck narrative and manage all data inputs with precision. With strong content writing skills and a methodical approach to organizing research, I’ll transform your raw notes into a clear, investor-ready story. I specialize in crafting persuasive scripts and structuring market insights into clean, impactful messaging. Let’s build a deck that speaks with clarity and conviction.

@nipun4446

n do this job and handover to you in just 45 minutes with ultimate perfection and i am very self motivated person

@mohammedr522

Give me few hours i do better sir give me work i do hard work money value for you never say anything

@MQamar123

As a seasoned professional with robust skills in Data Processing, I have the dexterity to handle high-level Excel functions and can help you build a powerful dynamic category sequencing formula. Though having extensive breadth in fields such as website and mobile app development, cloud computing, graphics designing, just to name a few, my penchant for creating elegant and efficient solutions give me an edge in problem solving irrespective of field. Specifically speaking on how I can assist you here is my deep understanding of Microsoft Office tools. I assure you of delivering not only a final formula but also comprehensive explanation and clear instructions on how it works and the successful way to integrate it into your sheet effortlessly. Being well-versed in COUNTIFS, SEQUENCE, UNIQUE or LET functions, I guarantee utmost stability even under the practical constraints you've outlined. Moreover, as someone who prioritizes understanding client-verifiable performance, I 'll gladly furnish you with a test sheet reflecting the dynamic sequencing format i.e "[sequence]/[total]" that meets your criteria embedded beside each row. Rest assured that regardless of any post-delivery editing on your part like sorting rows by date or changes made to the table structure, my formula will adjust automatically to maintain categorical integrity. Beyond this project conservation as well, I intent to build

@INNOSOLVEX

IAM A EXPERT OF EXCEL AND GET YOUR WORK DONE VERY FASTI AM FAST AND EFFICIENT WITH MY WORK YOU SHOULD NOT TO WORRY AND WE CAN NEGOTIATE ABOUT THE PRICE ALSO

@sajithaf

Hi, I understand you're looking for a dynamic Excel formula that generates a category-based ID in the format `[sequence]/[total in category]`, which resets with each category and remains stable even after sorting. I can deliver a pure-formula solution using *COUNTIFS*, *SEQUENCE*, *UNIQUE*, and *LET*, optimized for *Microsoft 365*. It will auto-adjust for new rows or category changes and maintain consistent sequencing post-sorting by date. If required, I can also provide a lightweight VBA fallback for enhanced stability. Let me know if you'd like a sample on your dataset. I’m ready to start immediately! Thanks, Sajitha

@abdullfauzi

I’m new on this platform, but I’ve been doing this for years. I help businesses save time and avoid messy spreadsheets using Excel, Power Query, and my accounting/audit experience. I don’t just finish tasks — I make them efficient, clean, and future-proof. And if you need more, I’m happy to go beyond what’s asked to make things even better Open to discuss budget and scope. Let’s make your data work smarter, not harder!