Hi!

Here's one way:

Enter your numbers in A1:A49.......1;2;3;4;5...49

Enter this formula in B1:

=RAND()

Enter this formula in C1:

=INDEX(A$1:A$49,RANK(B1,B$1:B$49))

Select both B1 and C1 and copy down to row 49.

Use C1:C6 as your numbers.

To generate a new draw just press F9. Theoretically, it's possible to get
repeats but highly unlikely.

Biff

"Carmel" wrote in message
...
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!