Hi - Dave here.
Excel has several functions for generating random numbers, including RANDBETWEEN, and RANDARRAY. However, there is no guarantee that the numbers from these functions will be unique. To get a list of
unique random numbers, you need a more robust formula.
For example, the formula below generates 1000 random numbers starting at 10,000, sorts the numbers randomly, then extracts the first 12 numbers. Because the original numbers are unique, the final numbers contain no duplicates.
[
Download the workbook and read the full explanation]
Note: The formula above requires Excel 365 or Excel 2021. In older versions of Excel you can take a more manual approach. The article and worksheet explain a formula based on INDEX and MATCH with the LARGE function.
More Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a fun and relaxing weekend.
Dave
