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

excel help

Topic closed. 6 replies. Last post 9 years ago by latin22.

Page 1 of 1
PrintE-mailLink
Avatar
New Member
Texas
United States
Member #53925
July 27, 2007
16 Posts
Offline
Posted: August 10, 2007, 3:13 pm - IP Logged

I'm working on a strategy for my lotto 6 game and I need a little help.I have a 200,000 combination file that I generated I want to be able to sort it out.I opened it in excel but I want to be able to sort it so that all the combinations beginning with a 1 are together, all the numbers beginning in 2 are together and so on like 

1,2,3,4,5,6

1,15,17,23,34,46

2,4,26,32,37,45

after that I wanted to be able to sort the file even further and group together combinations that end with the same last two numbers like this for example

3,4,5,6,23,24

3,15,18,20,23,24

3,10,12,18,23,24

I can't figure out how to do this in excel can anyone help me who knows how to do this? THanks for your help!!Smile 

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Offline
    Posted: August 10, 2007, 4:38 pm - IP Logged

    Latin,

    Try Big Al's Lotto Software Demo to generate combinations.

    Sent you a PM with the link.

    Program will generate all the combinations for whatever lottery you play.

    It willl save the combinations to a text file by 1st number sequence.

    Copy and paste into Excel.

    Have fun!!! 

      Avatar
      New Member
      Texas
      United States
      Member #53925
      July 27, 2007
      16 Posts
      Offline
      Posted: August 10, 2007, 5:56 pm - IP Logged

      I actually already have combinations I just want to sort them out.

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5387 Posts
        Offline
        Posted: August 10, 2007, 7:29 pm - IP Logged

        Ahh!!  Ok

        Well first of all Excel only has 65,000 plus rows (not sure about 2007 Excel version)

        Just highlight the 5 or 6 number group at the very top of the columns by holding down your left mouse button and drag as many columns that you want sorted.

        When you have you columns highlighted just go to the main menu and choose

        Data>Sort

        A window will open where you can sort by whatever cell row you want.  To the right you can select ascending (low to high) or descending (high to low)

        Click OK.

        This will sort according to whatever you selected.

        Hope this helped!! 

          Avatar
          New Member
          Texas
          United States
          Member #53925
          July 27, 2007
          16 Posts
          Offline
          Posted: August 10, 2007, 9:13 pm - IP Logged

          I appreciate it Steve I actually figured it out about an hour after I replied to your first response.I was able to get all the numbers to be sorted by the first number and the last number too.


            United States
            Member #16612
            June 2, 2005
            3493 Posts
            Offline
            Posted: August 16, 2007, 6:07 pm - IP Logged

            Good luck to you. I hope this combination comes out.

              Avatar
              New Member
              Texas
              United States
              Member #53925
              July 27, 2007
              16 Posts
              Offline
              Posted: August 16, 2007, 11:27 pm - IP Logged

              Thanks Just6ntlc.I can get the combinations sorted out but its still hard to pick combinations to play out of 200,000 generated combos.So far I have had no luck picking the right combonations but my generated combinations file have had 5-15 5 out of 6 hits for all three past lottery drawings.Anyway Good luck to you as well in lottery playing