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
Bookmarks