+ Reply to Thread
Results 1 to 3 of 3

I want to sequentially number a list ignoring blanks

  1. #1
    Registered User
    Join Date
    02-07-2014
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2

    I want to sequentially number a list ignoring blanks

    I have a column of week numbers but some gaps in the list (e.g. the job is complete and so I do not want to reference it) I am trying to create a list of jobs by week number. I need to sequentially number jobs to then use Vlookup e.g. job1-week1 job2-week1 etc to display be week.

    I can work out to number the list ignoring the blanks but then resetting to 1 with each new week?

    Please help its driving me mad!Workbook1.xlsx

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: I want to sequentially number a list ignoring blanks

    What is being reset to 1? The week numbers are not going to change because they are what they are.

    Is there something missing from this scenario that you are not showing?
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    02-07-2014
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: I want to sequentially number a list ignoring blanks

    if I have a list of week numbers I need to concatenate a number to the weeknumber to then look it up and display each weeks work in a separate column on a separate sheet. Without gaps this works if in cell a2 =if(a1=a2,b1+1,1) (assuming column a is the weeknumber) however when there are gaps in the weeknumber column I get repeat numbers which I then cannot vlookup. eg if weeknumber 6 has 10 rows, 2 of those rows might show a blank weeknumber (as we have finished the job)so ill end up with 1-6,2-6,3-6,then if there is a gap it goes back to 1-6. I only want to reset to 1 when the weeknum changes and ignore the blanks

+ 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. Function to Choose and List Values ignoring blanks and erros
    By k2i2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2013, 11:10 AM
  2. [SOLVED] Dividing list into quintiles, returning a value but ignoring blanks.
    By maxfiesta in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-06-2013, 12:42 PM
  3. [SOLVED] Ignoring blanks
    By jswainson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-09-2012, 02:14 PM
  4. Consecutive number list ignoring duplicates
    By jalexand in forum Excel General
    Replies: 6
    Last Post: 10-05-2010, 12:36 PM
  5. [SOLVED] Sequentially number occurences of a string in a list
    By Cerbera in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-06-2010, 12:43 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