Results 1 to 4 of 4

breaking a sequential serial range

Threaded View

shon breaking a sequential serial... 08-20-2012, 08:06 PM
Pete_UK Re: breaking a sequential... 08-20-2012, 08:56 PM
shon Re: breaking a sequential... 08-20-2012, 09:07 PM
Cutter Re: breaking a sequential... 08-20-2012, 09:34 PM
  1. #1
    Registered User
    Join Date
    03-07-2012
    Location
    Fiji
    MS-Off Ver
    Microsoft 365
    Posts
    23

    breaking a sequential serial range

    Hello,

    I have a list of serial ranges with different quantities.
    Would appreciate if a formula can be advised to break these ranges based on their quantity only.
    Please see attached, and below as example:
    Start Serial End Serial Qty
    3755386 3755400 15
    3755497 3755500 4

    For above, the result i need is:
    3755386
    3755387
    3755388
    3755389
    3755390
    3755391
    3755392
    3755393
    3755394
    3755395
    3755396
    3755397
    3755398
    3755399
    3755400

    and,
    3755497
    3755498
    3755499
    3755500

    Breaking the range is easy but I don't know how to make it stop at the end serial. Please assist - would prefer a formula....
    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