+ Reply to Thread
Results 1 to 3 of 3

Can you solve my problem?

  1. #1
    Keith Robinson
    Guest

    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. #2
    JE McGimpsey
    Guest

    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. #3
    Dave Peterson
    Guest

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts