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....
Bookmarks