Welcome Guest
Log In | Register )
You last visited December 9, 2016, 8:10 pm
All times shown are
Eastern Time (GMT-5:00)

Using excel to generate all possible Pick 6 combos

Topic closed. 5 replies. Last post 1 year ago by CARBOB.

Page 1 of 1
PrintE-mailLink
GreenbackStack's avatar - Lottery-050.jpg
New Member
CT
United States
Member #166926
June 16, 2015
22 Posts
Offline
Posted: June 30, 2015, 1:46 pm - IP Logged

Hi, Is it possible excel can generate all possible pick 6 combos for Connecticuts Lotto! ?  I can do it manually to the point where it will autofill to the 44, but then I'd have to stop and manually input the next number, then autofill to the 44 and so on..  There must be an easier way, if yes, can someone point me in the right direction?? Thanks!

Here's something to think about: How come you never see a headline like 'Psychic Wins Lottery'?

Jay Leno
    Todd's avatar - Cylon 2.gif
    Chief Bottle Washer
    New Jersey
    United States
    Member #1
    May 31, 2000
    23274 Posts
    Offline
    Posted: June 30, 2015, 2:10 pm - IP Logged

    Click Lottery Combinations Generator in the Resources menu.

     

    Check the State Lottery Report Card
    What grade did your lottery earn?

     

    Sign the Petition for True Lottery Drawings
    Help eliminate computerized drawings!

      GreenbackStack's avatar - Lottery-050.jpg
      New Member
      CT
      United States
      Member #166926
      June 16, 2015
      22 Posts
      Offline
      Posted: June 30, 2015, 2:38 pm - IP Logged

      i tried that, it seems like 7 million combos is too much to use the "select all" button..., the page turns all black...but it works when I generate every other combo, but I'm looking for ALL combos

      Here's something to think about: How come you never see a headline like 'Psychic Wins Lottery'?

      Jay Leno
        CARBOB's avatar - FL LOTTERY_LOGO.png
        ORLANDO, FLORIDA
        United States
        Member #4924
        June 3, 2004
        5912 Posts
        Offline
        Posted: June 30, 2015, 3:09 pm - IP Logged

        i tried that, it seems like 7 million combos is too much to use the "select all" button..., the page turns all black...but it works when I generate every other combo, but I'm looking for ALL combos

        https://app.box.com/s/qvqn6ucw1aa68n5s6ql9zrmrob1v1lo0

        This is a CSV file, open with notebook. You may be able to import to Excel.

          NightStalker's avatar - 50logo
          East of Columbus, OH
          United States
          Member #120843
          December 28, 2011
          451 Posts
          Offline
          Posted: June 30, 2015, 4:19 pm - IP Logged

          https://app.box.com/s/qvqn6ucw1aa68n5s6ql9zrmrob1v1lo0

          This is a CSV file, open with notebook. You may be able to import to Excel.

          Is there a similar table for the Ohio Classic lottery? 49 numbers, 13 million combos, I think.

          Life's Too Short To Be Unhappy Cool

            CARBOB's avatar - FL LOTTERY_LOGO.png
            ORLANDO, FLORIDA
            United States
            Member #4924
            June 3, 2004
            5912 Posts
            Offline
            Posted: June 30, 2015, 4:29 pm - IP Logged

            Is there a similar table for the Ohio Classic lottery? 49 numbers, 13 million combos, I think.

            Sorry, it doesn't work for neither. The program did not create all the combos.