Formula puts 1 to X value then starts at 1 again

[Daniel]

Hi Everyone,

I need formula that will count and put the number next to
a column of customer id's going up to 29 and then
starting at 1 again, in a repeating pattern. Can anybody
help?

Cheers

Daniel

 

[Frank Kabel]

Hi
in the first cell put the formula
=MOD(ROW(1:1),30)
and copy down

 

[JE McGimpsey]

One way:

B1: =MOD(ROW()-1,29)+1

Copy down as far as necessary.

 

[JE McGimpsey]

This formula restarts at 0, not 1.

 

[Frank Kabel]

Hi JE
yes, thanks for the correction

 

[Bernie Deitrick]

Daniel,

If you don't want to start your counting in row 1, then use a variation on
JE's formula. IF your first cell is E7, for example, then use the formula:

=MOD(ROW()-ROW($E$7),29)+1

HTH,
Bernie
MS Excel MVP

 

[BrianB]

Put 1 into cell A1 and copy formula down from A2 :-

=IF(A1=29,1,A1+1