For both fun and profit
How to Create Random Numbers in Excel (Including No Repeats)
There are a surprising number of ways you can use a random number generator in Excel. But before you do, it's important to understand the function of a random number generator and how you can use it for different applications.
Once you understand how to use random number functions, you can, for example, generate dummy sample data to test calculations, choose the order of players for a game, select winners for a competition, and much more.
The two functions in Excel that allow you to create random numbers are RAND, RANDBETWEEN, and RANDARRAY.
