 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Fill repeating Numbers
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?  SignatureThanks 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>. > 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 [quoted text clipped - 6 lines] > Thanks As Always > Rip SignatureDave 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.... SignatureWag more, bark less > 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 [quoted text clipped - 3 lines] > > Anyone know a trick other than copy and paste? 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 > 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 [quoted text clipped - 3 lines] > > Anyone know a trick other than copy and paste? =MOD(A1,8)+1 would do the same thing..... SignatureWag more, bark less > Put a 1 in cell A1 and put this formula in A2 > =IF(MOD(A1+1,9)=0,1,A1+1) [quoted text clipped - 7 lines] > > > > Anyone know a trick other than copy and paste? =MOD(A1,8)+1 Works as well SignatureWag more, bark less > Put a 1 in cell A1 and put this formula in A2 > =IF(MOD(A1+1,9)=0,1,A1+1) [quoted text clipped - 7 lines] > > > > Anyone know a trick other than copy and paste? Easier formula: =IF(H17+1>8,1,H17+1) > 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 [quoted text clipped - 3 lines] > > Anyone know a trick other than copy and paste? Thanks for the tips guys. I KNEW there had to be an easier way! SignatureThanks As Always Rip > Easier formula: > =IF(H17+1>8,1,H17+1) [quoted text clipped - 6 lines] > > > > Anyone know a trick other than copy and paste? 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 > Thanks for the tips guys. I KNEW there had to be an easier way! > [quoted text clipped - 8 lines] > > > > > > Anyone know a trick other than copy and paste? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.