I would agree with ChemistB's solution. Be aware that RANDBETWEEN is volatile so if your sheet recalculates the values are all going to change. If you use this formula to generate a long list of numbers then check for duplicates using the formula provided, you can tweak those by hand to be unique. However, I used those formulas to generate 6500 numbers and in 20 trials did not find a single duplicate.