Welcome Guest
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
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!!

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!!!

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.

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!!

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.

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

 Page 1 of 1