Excel Forum
Similar Content
Multi-Column ComboBox Drop Down Menus in Forms
Tutorial: Multiple columns of data within a UserForm ComboBox drop-down menu in Excel. I'll show you...
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 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.