Excel Forum



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.