same number appears in a random number generator
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!
|