+1 Stop Counting and Start Back to 1

[Iccreamann21]

a	b	c	d	e
1	1
2	=B1+1
3	=B2+1
4	=B3+1
5	=B4+1
6
7
8
9

<tbody>
</tbody>

Hello All! I was wondering if someone could help me with a formula to cycle back to the number 1 after it reaches a limit of 83. I was using the formula above, but when it gets to 83 i want it to start over to 1? Any ideas? Thank you so much!

 

[Eric W]

Put 1 in B1, and this formula in B2:

=MOD(B1,83)+1


If you want to start in the top row, you can put this in B1:

=MOD(ROW()-1,83)+1