Can you solve my problem?

[Keith Robinson]

Hi
How can I randomly select six different numbers at any one time i.e lottery
numbers. I have tried using the formula below,
=INT(RAND()*49)+1, which works OK but I get repeated numbers in a line of
six, can anyone
help?
Keith

 

[JE McGimpsey]

For one way, see:

http://www.mcgimpsey.com/excel/randint.html


Usage: Select six cells and array-enter

=RandInt(1,49)

 

[Dave Peterson]

You got multiple responses to your first post.

Hi
How can I randomly select six different numbers at any one time i.e lottery
numbers. I have tried using the formula below,
=INT(RAND()*49)+1, which works OK but I get repeated numbers in a line of
six, can anyone
help?
Keith