LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Nelson
 
Posts: n/a
Default Consecutive Numbers down a column not to Exceed 49

Hi there,

I have 6 columns across going 40 rows down. I'm entering random numbers in
row 1 across columns A to F. The numbers have to stay in a range from 1 to
49 but are totally random in row 1. From rows 2 through 40 I want the
numbers to automatically fill down consecutively but not to exceed 49. When
a certain column hits 49 I want that column to start over at 1 again.

Im a total newbie when it comes to excel.

I did try entering A1+1 in cell A2 and then highlighting the remaining rows
down to 40 in column A. I then went to the edit menu and choosing fill €“
down. The problem here was that when I entered any number larger than 10 in
row 1 I would go over 49 somewhere down the column. I need the numbers to
start back at 1 when 49 is reached.

A B C D E F
Row 1 46 31 7 15 43 19
Row 2 47 32 8 16 44 20
Row 3 48 33 9 17 45 21
Row 4 49 34 10 18 46 22
Row 5 1 35 11 19 47 23
Row 6 2 36 12 20 48 24
Row 7 3 37 13 21 49 25
Row 8 4 38 14 22 1 26
Row 9 5 39 15 23 2 27


Thanks in Advance
Nelson

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
column filtering to match identical numbers sammc2 Excel Discussion (Misc queries) 1 July 14th 05 11:59 PM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
add only positive numbers and avg in a column rich Excel Worksheet Functions 6 March 10th 05 09:19 AM
How can I sort an entire spreadsheet from a list prod sorter Excel Worksheet Functions 4 November 17th 04 03:43 AM


All times are GMT +1. The time now is 09:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"