Hi everyone!

I have this project for a client who wants me to produce 200,000 pcs of scratch cards (for mobile phones) and the last time I tried generating 6,000 "random unique-non repeated numbers" using randbetween there were about 150 duplicates that came up. I would like to know how if there is really a way in excel to do this..

any help will be appreciated..

by the way, below is a sample:

SERIAL PIN

20319422 ACA95368


thank you!!