Excel Magic Trick 1473: Sequential Number Incrementor for Just The Middle Number: AA-0009-17

Download Files: http://ift.tt/2BAGcz3
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Learn about how to create a formula to create a product code where the middle part of the code must increment as it is copied down a column. See the Functions ROWS and TEXT. ROWS is good for incrementing numbers inside formulas – it is better than the ROW function because it allows structural changed to the spreadsheet whereas ROW Function does not. Also see the TEXT Function to format numbers with Custom Number Formatting and convert them to text.

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.