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.