If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table of incrementing by one numbers
I would like to be able to enter a number in the first cell and have it populate a table - 6 columns by 30 rows - incrementing each cell by one. For ex, if I enter 100 in the first cell, the rest of the row would be 101,102,103,104,105. The next row would be 106, 107, 108, 109, 110, 111. Etc. Is there a easy way to do this? Thanks, Someone who rarely uses Excel -- brbarto ------------------------------------------------------------------------ brbarto's Profile: http://www.excelforum.com/member.php...o&userid=29755 View this thread: http://www.excelforum.com/showthread...hreadid=494773 |
#2
|
|||
|
|||
Table of incrementing by one numbers
brbarto, one way, with 100 in A1, in B1 put =A1+1, select b1 and click on
the fill handle, the little black square on the bottom right , and drag it over to column F now in A2 put =A1+6 and drag it over to column F next select A2:F2 and drag it down to row 30, that should do it. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "brbarto" wrote in message ... I would like to be able to enter a number in the first cell and have it populate a table - 6 columns by 30 rows - incrementing each cell by one. For ex, if I enter 100 in the first cell, the rest of the row would be 101,102,103,104,105. The next row would be 106, 107, 108, 109, 110, 111. Etc. Is there a easy way to do this? Thanks, Someone who rarely uses Excel -- brbarto ------------------------------------------------------------------------ brbarto's Profile: http://www.excelforum.com/member.php...o&userid=29755 View this thread: http://www.excelforum.com/showthread...hreadid=494773 |
#3
|
|||
|
|||
Table of incrementing by one numbers
Just another play to try ..
Assume the starting number will be entered in a cell outside the 6 C x 30 R table, say, in G1 Then we could populate the table by placing in any starting cell, say, in A1: =IF($G$1="","",$G$1+ROW(A1)*6-6+MOD(COLUMN(A1)-1,6)) and copy A1 across 6 cols to F1, fill down by 30 rows to F30 (or copy A1 down by 30 rows to A30, fill across 6 cols to F30) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "brbarto" wrote in message ... I would like to be able to enter a number in the first cell and have it populate a table - 6 columns by 30 rows - incrementing each cell by one. For ex, if I enter 100 in the first cell, the rest of the row would be 101,102,103,104,105. The next row would be 106, 107, 108, 109, 110, 111. Etc. Is there a easy way to do this? Thanks, Someone who rarely uses Excel -- brbarto ------------------------------------------------------------------------ brbarto's Profile: http://www.excelforum.com/member.php...o&userid=29755 View this thread: http://www.excelforum.com/showthread...hreadid=494773 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |