+ Reply to Thread
Results 1 to 4 of 4

Autonumber cells, skip cell with blank reference, begin renumbering at 1

  1. #1
    Registered User
    Join Date
    03-20-2012
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Autonumber cells, skip cell with blank reference, begin renumbering at 1

    I would like to number cells 1,2,3 and so on in column B if the cell in column c is not blank. When column c is blank I want the numbering to stop in column B and then restart with 1 when there is a value in column C. Attached is a sample of what I am trying to accomplish. Thank you for your help.

    auto number sample.xlsx

    Screen Shot 2017-04-27 at 1.41.48 PM.png

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Autonumber cells, skip cell with blank reference, begin renumbering at 1

    Try this in B3:

    =IF(C3="","",SUM(B2,1))

    then copy down as far as you need to.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    03-20-2012
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Autonumber cells, skip cell with blank reference, begin renumbering at 1

    You are a Godsend!!! This worked. Thank you.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Autonumber cells, skip cell with blank reference, begin renumbering at 1

    Glad to help - thanks for the rep.

    Pete

+ 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. Renumbering and deleting blank rows after finding and removing duplicates
    By babebull82 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-10-2016, 06:52 PM
  2. [SOLVED] Go to right thru a range and skip all blank cells, return value of first non-blank in rang
    By mysticmoron109 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-16-2015, 03:47 PM
  3. [SOLVED] Autonumber to skip blank lines and then and restart number series
    By mcranda in forum Excel General
    Replies: 6
    Last Post: 09-04-2015, 05:12 PM
  4. [SOLVED] Combine multiple cells text into one cell, skip blank cells.
    By T15K in forum Excel General
    Replies: 6
    Last Post: 12-05-2014, 09:49 PM
  5. [SOLVED] How to make Excel VBA to skip blank cells until a cell has a number
    By vnzerem in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-11-2013, 08:29 PM
  6. Replies: 4
    Last Post: 04-09-2012, 12:06 PM
  7. Replies: 4
    Last Post: 07-15-2008, 01:42 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