Formula Auto-Increment After So Many Rows
This Excel auto-increment formula includes the ability to control the interval of the increment and the increment itself.
The automatic interval formula allows you to more easily make lists of values or more advanced formulas that use functions like the INDIRECT() function to make interval-based advanced range references.
The techniques in this tutorial are explained step-by-step so that everyone can understand them and I break down the final formula into pieces and build it up so that you can see how everything works separately and together.
INT() Version
=INT((ROW(A1)-1)/5)ROUNDDOWN() Version
=ROUNDDOWN((ROW(A1)-1)/5,0)Watch the above video to see how these formulas work and how to change them to suit your needs.
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: (New Easier Version for Excel 2010 and Later) How to increment a value, number, percent, e...
Tutorial: Create a pop-up window, splash screen, that appears when Excel starts. This allows you to ...
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
Tutorial: Here, I'll show you a quick, simple, and effective way to fix formulas and functions in E...
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions. Index and Ma...
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)