+ Reply to Thread
Results 1 to 5 of 5

help:Auto Numbering

  1. 11-13-2009, 06:00 PM #1
    dropdesigns
    dropdesigns is offline
    Registered User
    Join Date
    11-13-2009
    Location
    Paso Robles Ca
    MS-Off Ver
    Excel 2003
    Posts
    3

    help:Auto Numbering

    I need some help with a formula this to save me alot of time, pain and anguish. I have a work sheet with two collums and 11,000 rows. In collum A I have mulitple grouped series of like number (exactly the same) sepperated by a blank row. Each group of like numbers does not contain the same number of instances each time. In collum B I would like to auto number each group starting at 0 continueing through the series then skip the blank row and start the like group at 0 again. I will attach a sample of what I am trying to accomplish. Any help would be greatly appreciated.
    Thanks
    Dustin
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-13-2009, 06:17 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    re: help:Auto Numbering

    Welcome to the forum.

    In B2 and copy down, =IF(ISNUMBER(A2), IF(ISNUMBER(A1), B1+1, 0), "")

    I edited your thread title to remove the spurious words. Please take a few minutes to read the forum rules before starting a new thread.

    Thanks.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 11-13-2009, 06:26 PM #3
    dropdesigns
    dropdesigns is offline
    Registered User
    Join Date
    11-13-2009
    Location
    Paso Robles Ca
    MS-Off Ver
    Excel 2003
    Posts
    3

    re: help:Auto Numbering

    Thanks! sorry about breaking the rules right out of the gate. I will be more careful in the future. Thank again for your help with this.
    Reply With QuoteRegister To Reply
  4. 11-13-2009, 06:36 PM #4
    dropdesigns
    dropdesigns is offline
    Registered User
    Join Date
    11-13-2009
    Location
    Paso Robles Ca
    MS-Off Ver
    Excel 2003
    Posts
    3

    re: help:Auto Numbering

    One more quick question, what if the number group contained Alpha & Numeric values?
    Reply With QuoteRegister To Reply
  5. 11-13-2009, 06:43 PM #5
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    re: help:Auto Numbering

    Then insert a blank row between the header and the data, and in B3 and copy down, =IF(ISBLANK(A3), "", IF(ISBLANK(A2), 0, B2+1) )
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1