=RANDBETWEEN(1,50) but neither that nor your formula will ensure that the
numbers are unique.
--
David Biddulph

"Colin" wrote in message
...
I have a lottery worksheet to design which will produce 6 unique numbers
between 1 and 50 in six cells.
I use =INT(RAND()*51) at the moment which works well. How do I alter this
function so that 0 does not appear as one of the numbers?
--
Thank you,

Colin.