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
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
For one way, see:
http://www.mcgimpsey.com/excel/randint.html
Usage: Select six cells and array-enter
=RandInt(1,49)
In article <[email protected]>,
"Keith Robinson" <[email protected]> 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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks