# Can you solve my problem?

1. ## Can you solve my problem?

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

2. ## Re: Can you solve my problem?

For one way, see:

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

Usage: Select six cells and array-enter

=RandInt(1,49)

In article <boA7e.20406\$Uc7.7578@newsfe2-win.ntli.net>,
"Keith Robinson" <Keith.Robinson28@ntlworld.com> wrote:

> 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

3. ## Re: Can you solve my problem?

You got multiple responses to your first post.

Keith Robinson wrote:
>
> 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

--

Dave Peterson