How To Create Random Number Generator in Excel No Repeats (2026 Quick & Easy)
This is how you can create a random number generator in Excel with no repeats. This works on PC, on Mac, and of course, Excel on the web. And it's super easy. What we want to do is select on any cell and then press on enter and type in the word unique. And we're going to select on the function of unique. From here, it's going to open up a bracket. We're going to start typing in rand and select on the option of rand array or random array. Now, it's going to ask how many rows, columns, the number set we want, and of course, whether we want it as a whole number or decimals. Then the last option is do we want it with decimal points or do we want it as whole numbers. I'm going to select on true and this means it's going to have whole numbers. Now I'm going to close this bracket