+ Reply to Thread
Results 1 to 8 of 8

Sequential Numbering

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    Jet Park, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    4

    Post Sequential Numbering

    Hi
    I need to generate a UNIQUE alphanumeric number sequence (with the emphasis on unique) for an on pack, laser coding, phone in competition. The number sequence needs to be 6 characters long. Initially I was looking at creating a random alphanumeric number sequence, but, from what I can conclude, doing it this way might lead to number duplication and if we do that with a large prize winner we would have big issues. Bearing this in mind, I thought sequential numbering was the better way to go. How do I do this in Excel? (From what I can see, this gives me 6 Billion options). The alternative is going 5 character long which will give me 60 million options or, as a last resort, 4 characters long which will give me 1.6 million options.
    Thanks
    Peter

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Sequential Numbering

    Hi Peter,

    Welcome to the forum.

    If I put it in simple terms -> do you need 6 character long non repeating list? If Yes, then how many cells ?


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    04-11-2013
    Location
    Jet Park, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Re: Sequential Numbering

    Thanks for your reply. I was looking at in excess of 30 million cells - if that is possible.

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Sequential Numbering

    Hi Filtec,

    Excel has rows limitations of 1048576



    Regards,
    DILIPandey
    <click on below * if this helps>

  5. #5
    Registered User
    Join Date
    04-11-2013
    Location
    Jet Park, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Sequential Numbering

    Thank you for your feedback and advising me of Excel row limitation. This in itself is not a problem, because it would not be a proble breaking the groups up into a million at a time. In actual fact, each production run is only about quarter of a million, so even batches of 250 000 would not be a problem.

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Sequential Numbering

    HI Filtec,

    Found below article in Microsoft site:-

    http://support.microsoft.com/kb/151470


    Regards,
    DILIPandey
    <click on below * if this helps>

  7. #7
    Registered User
    Join Date
    04-11-2013
    Location
    Jet Park, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    4

    Thumbs up Re: Sequential Numbering

    You have resolved my problem - thank you.

  8. #8
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Sequential Numbering

    you are welcome Filtec .. cheers



    Regards,
    DILIPandey
    <click on below * if this helps>

+ Reply to Thread

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