increment numbers formula

  1. M

    Formula to increment numbers 1,1,1,2,2,2,etc.

    Dear Smartest Excelers In The World, I would like a formula that I could copy down column A that would give me a column of numbers like this: 1;1;1;2;2;2;3;3;3;4;4;4 etc. I have used formulas like this: =MOD(ROWS(A$1:A1)-1,3)+1 to give me a column of numbers like this: 1;2;3;1;2;3;1;2;3...

Some videos you may like

This Week's Hot Topics

Top