Excel Forum
Similar Content
Change Formulas to Absolute or Relative References
Macro: This macro will change the formulas in cells to absolute or relative. It allows you to cha...
Filter Data in Excel to Display Results that Contain 1 of 2 Possible Values - AutoFilter
Macro: This Excel macro filters data in Excel to display results that contain 1 of 2 possible val...
Excel VBA - Create an Array - 3 ways
Tutorial: Ill show you three different ways to create an array in Excel VBA and Macros and how to ge...
Excel VBA Course
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.)

View Course




Excel Magic Trick 649: Formula to increment number pattern 1,1,1,2,2,2,3,3,3...


From Aladin and Hot Pepper at the Mr Excel Message Board see two great formulas to increment a number pattern using the INT, ROW and ROWS functions and the act of dividing by 3. Amazing formulas.





Got a Question? Ask it Here in the Forum.