Code to generate 2000 unique 8 digit numbers

[Excelski]

Hi All,

Can someone help with some code to generate 2,000 unique 8 digit numbers

Thanks

Kevin

[dominicb]

Good morning Excelski

Why code?
Code writing is work intensive for someone to do, but this could be done in one worksheet with a few formulae, to generate the random numbers, and double check they are all unique.

DominicB

[Excelski]

Hi DominicB,

Thanks for looking, I had assumed that code was needed for this task, but I am happy with formulas

Kevin

[AliGW]

Nonetheless, there are lots of free solutions out there. Here is one: https://www.exceltip.com/tips/random...ut-repeat.html

Adapted workbook from that link attached.

[dominicb]

Hi Excelski

In A1 put this formula and copy down to 2000.

Please Login or Register  to view this content.

In B1 put this formula and copy down.

Please Login or Register  to view this content.

Put this formula in C1.

Please Login or Register  to view this content.

As long as C1 gives the answer 2000, there will be no duplicates. If C1 doesn't equal 2000, then just recalculate.

HTH

DominicB

[Excelski]

Thank you both!

Both solutions work great

Kevin

[AliGW]

You're welcome!