Results 1 to 6 of 6

Numbering a sequential list, but exclude a list of given numbers.

Threaded View

  1. #1
    Registered User
    Join Date
    08-09-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    9

    Numbering a sequential list, but exclude a list of given numbers.

    Hello Excel-experts,

    PROBLEM:
    The user defines a MINIMUM and a MAXIMUM value (whole numbers) as well as a list of some numbers to be excluded.
    Required is:
    1. A list with all numbers from MIN to MAX without the numbers from the exclude-list.
    2. All numbers from the required list should be numbered sequentially in a separate row.


    Please check out my sample worksheet in which you can see my (poor) attempt at solving my numbering-problem as well as three examples of what I would like to accomplish. I also give some comments of what means what and what doesn't work.


    Any help is really appreciated.


    Kind regards,
    Fie Buls

    P.S. I hope the attaching of the worksheet will work... if not I will look in the help to figure out how to do it :-)
    Attached Files Attached Files

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