Repeat values

[TripletDad]

This shouldn't be that hard, but I can't figure it out.

I want to repeat 1,2,3,4,5 for ~4500 cells.

A1 = 1
A2 = 2
A3 = 3
A4 = 4
A5 = 5
A6 = 1
A7 = 2
A8 = 3
A9 = 4
A10 = 5
...etc

Why is this giving me a hard time?

 

[kpark91]

Put this in A1 and copy down.
Interested to see how other people do it tho.
=IF(MOD(ROW(), 5), MOD(ROW(), 5), 5)

 

[jasonb75]

Try

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

and fill down.

 

[TripletDad]

Try

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

and fill down.

Jason - my bad...

What if I want to start on Row2?

 

[kpark91]

=if(mod(row()-1, 5), mod(row()-1, 5), 5)

 

[jasonb75]

Try

=MOD(ROWS(A$22:A22)-1,5)+1

 

[TripletDad]

Try

=MOD(ROWS(A$22:A22)-1,5)+1

Perfect!!!

Thanks!

 

[Armando Montes]

Enter 1 in A2 and select it
Edit/Fill/Series
Series in columns
Stop value: 5000
Enter