• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unique, Non Serialised, Random Numbers

A

araugustine

New Member
Hi,

For a project, I need to generate unique, non serialised random numbers - in fact, I need to generate 30 lakh such codes,with ten digits.


Is this possible in excel 2007 and if so, how?


thx in advance

rgds

AR Augustine
 
AR Augustine


Have a read of: http://chandoo.org/wp/2011/05/04/dummy-data-random-functions/
 
Thanks for the tip, I used randbetween(1000000000,9999999999) and then used "remove duplicate" function in excel 2007 to eliminate duplicates, bingo, the 3 million codes were generated.
 
You must log in or register to reply here.
Back
Top