Generating 500,000 random unique numbers

[chris meardon]

Hi Guys,

I need to produce half a million random unique numbers onto a spreadsheet.

Can you guys help? obviously the rand function is ok but the numbers arent unique.

the numbers need to be within 1-9999

the other issue i have is displaying the numbers, all numbers need 4 digits, for example if the number is 35 it would need to be displayed 0035 to have 4 digits.

Thanks

 

[wigi]

The RANK function will give you the unique numbers, not those generated by the RAND. They're only intermediate.