+ Reply to Thread
Results 1 to 5 of 5

How to do sequential numbering every other row and column

  1. #1
    Registered User
    Join Date
    05-01-2015
    Location
    United Kingdom
    MS-Off Ver
    Office 2013
    Posts
    12

    How to do sequential numbering every other row and column

    Hi There,

    I'm looking to create a spreadsheet where I enter a number into a cell (A2 in this case) and then that will auto fill the cells in every other row with the next sequential number but once it gets to say row cell A24 I would like it to start in column C and vice versa for every other column (see attached image for reference).
    I've found the following formula that achieves the every other row part but I'm stuck on how to continue that when I want to move to the next column.
    Please Login or Register  to view this content.
    I've attached an image that shows what I'm trying to achieve.

    Any help on this would be greatly appreciated.

    Many thanks,

    Dom
    Excel.JPG

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: How to do sequential numbering every other row and column

    See attached.

    You can copy columns A and B to the right to extend formulas.
    Attached Files Attached Files
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Registered User
    Join Date
    05-01-2015
    Location
    United Kingdom
    MS-Off Ver
    Office 2013
    Posts
    12

    Re: How to do sequential numbering every other row and column

    Thanks modytrane, that works perfectly.

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: How to do sequential numbering every other row and column

    Refer attached workbook

    With a slightly different layout
    - specify the starting value in A2
    - specify the no of items per column in B2 (variable)
    - empty cells returned automatically when number of items per column exceeded
    - single formula copied down and across

    In C2
    =A2-1

    In C4 copy down and across including blank columns and rows
    =IF((ROW()-3)/2<$B$2,IF(COLUMN()=3,IF(ISNUMBER(C2),C2+1,""),IF(ISNUMBER(A4),A4+$B$2,"")),"")

    Sequential.jpg
    Attached Files Attached Files
    Last edited by kev_; 03-06-2018 at 11:33 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  5. #5
    Registered User
    Join Date
    05-01-2015
    Location
    United Kingdom
    MS-Off Ver
    Office 2013
    Posts
    12

    Re: How to do sequential numbering every other row and column

    Thank you kev_ for the alternative solution, works well.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Assistance-Add sequential numbering in column A
    By pingman3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2018, 05:52 PM
  2. Sequential column numbering with reset
    By rockotoo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-30-2014, 08:58 PM
  3. How to add sequential numbering down a column until the next number 1 and start over
    By diaphanous1138 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-13-2014, 04:52 PM
  4. Sequential numbering........................
    By N80RUL in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2013, 10:58 PM
  5. [SOLVED] Sequential Numbering
    By Mel in forum Excel General
    Replies: 10
    Last Post: 05-09-2006, 10:15 AM
  6. Sequential Numbering Help
    By BadgerFanToo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-10-2005, 02:05 PM
  7. Sequential numbering
    By REELAXER in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 12:05 PM

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