Formula to Count Up to a Specific Value as Repeating Number

Originally Posted by FDibbins

No need for VBA for this. Put this in the cell where you want the numbering to start, and copy down...
=INT(ROW(A1)/20)+1

(not sure how this will be affected by subtotals, though)

Thanks! Works great. If subtotals affect it, I'll just copy and paste with values.