Note that RANDBETWEEN() will not guarantee unique values.


In article ,
Naz wrote:

1) Randbetween(lower,upper) formula
2) if You have a list of random numbers u could put a number to the left of
that column and the create a vlookup based on a random number to pull back
that number

=vlookup(randbetween(1,6),$A$1:$A$6,2,false)