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

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.

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

--

Dave Peterson

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....
--
Wag more, bark less


"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

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

Easier formula:
=IF(H17+18,1,H17+1)


"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

=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

=MOD(A1,8)+1
Works as well
--
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

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


"dhstein" wrote:

Easier formula:
=IF(H17+18,1,H17+1)


"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

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


"Ripper" wrote:

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


"dhstein" wrote:

Easier formula:
=IF(H17+18,1,H17+1)


"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