+ Reply to Thread
Results 1 to 3 of 3

Table of incrementing by one numbers

  1. #1
    Registered User
    Join Date
    12-19-2005
    Posts
    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

  2. #2
    Paul B
    Guest

    Re: 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" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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. #3
    Max
    Guest

    Re: 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" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1