+ Reply to Thread
Results 1 to 4 of 4

Sequential Number

  1. #1
    Registered User
    Join Date
    07-11-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    38

    Sequential Number

    Hi Team,

    Need your help on below. i get source input in the following way (excel format) and i have to show the recrods where there is a sequence in Invoice No.

    Input from source
    Vendor Invoice No
    V1 100
    V1 101
    V1 102
    V1 103
    V1 107
    V1 108
    V1 109
    V1 111
    V1 113
    V1 115
    V1 116

    Output required :

    Vendor Invoice No
    V1 100
    V1 101
    V1 102
    V1 103
    V1 107
    V1 108
    V1 109
    V1 115
    V1 116

    regards,
    Kamal M.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Sequential Number

    So why is 115 sequence and 113 not?

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Sequential Number

    @zbor: Probably because 113 is not part of a range, there is no 112 or 114, I imagine.
    Same goes for 111 I guess.

    eg.
    100-103
    107-109
    115-116

    are all ranges
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Valued Forum Contributor TheCman81's Avatar
    Join Date
    11-06-2012
    Location
    Edinburgh, UK
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    346

    Re: Sequential Number

    Still trying to figure out how to list them underneath each other but here's one way of doing it if you can work with it

    Sequential Number v1.xlsx
    Excel Guru in the making

    <----------If the question has been answered to your satisfication please click the Add Repuation star to the left

+ 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. [SOLVED] how to keep in standard sequential number?
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2013, 08:26 AM
  2. Replies: 10
    Last Post: 10-30-2013, 07:29 PM
  3. Sequential Number macro
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-15-2010, 05:36 PM
  4. sequential number
    By Malissa in forum Excel General
    Replies: 3
    Last Post: 08-15-2005, 05:05 PM
  5. [SOLVED] sequential number
    By Mike W in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-12-2005, 07:06 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