=MOD(A1,8)+1 would do the same thing.....
--
Wag more, bark less


"dhstein" wrote:

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



"Ripper" wrote:

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?
--
Thanks As Always
Rip