Fill repeating Numbers

[Ripper]

Is there a way to fill a repeating set of numbers. I have students listed by
their daily schedule. 1st period - 8th period. I want to create a period
column and have it fill in 1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8
all the way down the column to the last student. I tried fill series and
fill trend and even the fill handle to no avail.

Anyone know a trick other than copy and paste?

 

[Dave Peterson]

You can use a formula like:
=mod(row(),8)+1
And you'll see a pattern like the one you want.

But you may have to adjust the starting point depending on what the first row
is:

=mod(row()+5,8)+1

If you don't get 1, try again <vbg>.

 

[Brad]

One easy way
assume 1 is in a5
assume 2 is in a6
assume 3 is in a7
assume 4 is in a8
assume 5 is in a9
assume 6 is in a10
assume 7 is in a11
assume 8 is in a12
in cell a13 have the equation =a5

Copy this down as many times as needed....

 

[dhstein]

Put a 1 in cell A1 and put this formula in A2
=IF(MOD(A1+1,9)=0,1,A1+1)
Then copy it down

 

[dhstein]

Easier formula:
=IF(H17+1>8,1,H17+1)

 

[Brad]

=MOD(A1,8)+1 would do the same thing.....

 

[Brad]

=MOD(A1,8)+1
Works as well

 

[Ripper]

Thanks for the tips guys. I KNEW there had to be an easier way!

 

[Andrea Jones]

You can use the fill handle. Highlight the numbers 1-8 then hold down CTRL
while dragging the fill handle.

Andrea Jones
http://www.stratatraining.co.uk
http://www.wrekinpublishing.com