Carmel Wrote:
My formula for a lottery number selector is =INT(49*RAND()) but the
problem
is that sometimes it generates the same numbers two or more times. I
know
its something to do with the IF function, but can work out how to stop
it.
Please Help!

I believe Biff's given you a couple of good solutions.....just to also
point out that using

=INT(49*RAND())

would not only generate repeats but would also sometimes give you zero
....and never give you you 49.....!!


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=545736