Looking up multiple items in Excel to increase chances of winning CT Cash 5Prev TopicNext Topic

• GreenbackStack

  

  CT
  United States
  Member #166,918
  June 16, 2015
  22 Posts
  Offline
  Jun 18, 2015, 10:12 am

  ▲▼

  Hello.

  Is there anyway I can find multiple items in my Excel sheet? I'm working with two sheets, one that has 365 winning lottery combos, while the other has all possible combos. I'd like to find all the winning combos in the list of all possible combos and cross them out so I can have a better visual of what combos not to pick. I've been using the find button for each one individually, but it's taking a lot of time. Is there anyway I can speed this up? Thank you!!
• lottolaughs

  

  Sunny California
  United States
  Member #40,294
  May 31, 2006
  9,088 Posts
  Offline
  Jun 18, 2015, 10:26 am

  ▲▼

  My suggestion is to only concern yourself with combos that begin with 1,2 or 3 as these are most drawn.

  If you upgrade to Platinum you'll be able to search drawings quickly.

  Search 1-2,1-3,1-4,1-5 etc up to 1-10 as, again, these are most drawn and then you'll be able to mark them off quickly. See example below using the Search Drawings Tool here on the LP. 

  Search Connecticut Cash 5 Past Results

  Modify search criteria

  Start a new search

  • Game(s): Connecticut Cash 5
  • Match Type: Positional search
  • Minimum Numbers to Match: 2
  • Date range: All Available History
  • 128 drawings matched the search criteria specified

  Draw Date	State	Game	Results
  Sun, Jun 14, 2015	Connecticut	Cash 5	01-02-14-20-27
  Sat, May 16, 2015	Connecticut	Cash 5	01-02-03-09-20
  Mon, Mar 9, 2015	Connecticut	Cash 5	01-02-12-32-33
  Sun, Mar 1, 2015	Connecticut	Cash 5	01-02-10-19-25
  Sun, Feb 1, 2015	Connecticut	Cash 5	01-02-10-21-24
  Wed, Dec 24, 2014	Connecticut	Cash 5	01-02-05-18-27
  Tue, Jul 8, 2014	Connecticut	Cash 5	01-02-03-04-09
  Tue, Jun 24, 2014	Connecticut	Cash 5	01-02-04-10-15
  Tue, Jun 3, 2014	Connecticut	Cash 5	01-02-19-24-32
  Mon, May 19, 2014	Connecticut	Cash 5	01-02-03-26-31

  Now do the same with the 2-3, 2-4,2-5 etc to 2-10

  and again with 3-4, 3-5 etc to 3-10.

  Of course you can go ahead with the 4's, 5's, etc but in my opinion it's not worth the time.

  Read my recent blog if you are interested in receiving a copy of my Pick 5 Fever book.

  Just my 2 cents.
• Tialuvslotto

  

  Texas
  United States
  Member #150,790
  December 31, 2013
  824 Posts
  Offline
  Jun 19, 2015, 6:42 am

  ▲▼

  Use the following formula:

  =SUMPRODUCT(--ISNUMBER($C10:$I10),--ISNUMBER(MATCH($C10:$I0,$C$6:$I$6,0)))

  C6: I6 is the winning combination.  I put this up at the top of my spreadsheet.

  C10:I10is the combination you want to check, copy down to see the number of matches for each of your 385 combinations.  Change the cell references to match the parameters of your lotto game (eg. 5,6,7 numbers).  You can also add conditional formatting to have winning combos show up in bold, red or some other format that makes them easy to visually pick out of a long list.

  "There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."

  ~Robert A. Heinlein
• GreenbackStack

  

  CT
  United States
  Member #166,918
  June 16, 2015
  22 Posts
  Offline
  Jun 19, 2015, 9:39 am

  ▲▼

  thanks i will try that asap
• GreenbackStack

  

  CT
  United States
  Member #166,918
  June 16, 2015
  22 Posts
  Offline
  Jun 19, 2015, 11:19 am

  ▲▼

  How do I attempt to use this?
• Tialuvslotto

  

  Texas
  United States
  Member #150,790
  December 31, 2013
  824 Posts
  Offline
  Jun 19, 2015, 3:01 pm

  ▲▼

  Set up your spreadsheet as follows:

  Row 1, Columns C to I -- most recent winning numbers (this assumes 7 numbers -- use the number of cells you need and adjust the formula accordingly)

  Rows 5 to 390 -- your 385 combinations, in columns C to I (or however many columns you need)

  Row 5, column K -- enter the sumproduct formula:

  =SUMPRODUCT(--ISNUMBER($C5:$I5),--ISNUMBER(MATCH($C5:$I5,$C$1:$I$1,0)))

  Make sure that the cell references correspond to the appropriate cells and that you include all the dollar signs ($) as they are in the formula.

  Copy the formula in cell K5 down to cell K390.  The formula will produce the number of matches between each of your 385 sets and the winning set at the top of the page.

  "There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."

  ~Robert A. Heinlein
• butch2030

  

  The KEY ingredient is Combos & Patterns

  Elgin, IL
  United States
  Member #68,865
  January 1, 2009
  1,291 Posts
  Offline
  Jun 19, 2015, 5:42 pm

  ▲▼

  I'd like to find all the winning combos in the list of all possible combos and cross them out so I can have a better visual of what combos not to pick.

  Why??????  If you have winning combos, why would you cross them out.  I would think you would just do just the reverse.  I just took a look at your CT Cash 5 game.  I download the winning numbers going back to 01/01/2013.   There have been 899 drawings from 01/01/13 - 06/18/15. If you look at the numbers 10 11 12 20 23 26 27.  You will see below how they would have hit with 3 or more numbers in past drawings in the time framed listed above.  There are combinations of numbers & patterns  in every jackpot game that I look at barring none.

  Food for thought

  Good Luck & Best Wishes..................... 

  DATE	#1	#2	#3	#4	#5	# of hits
  2013-01-15	10	11	12	20	27	5
  2013-01-17	10	20	23	26	27	5
  2013-06-01	10	11	20	26	27	5
  2014-11-29	11	12	20	23	27	5
  2013-06-06	10	12	21	26	27	4
  2014-05-06	3	11	20	23	27	4
  2015-01-26	11	12	23	25	26	4
  2013-01-26	12	15	23	26	30	3
  2013-02-16	19	23	24	26	27	3
  2013-03-23	11	14	15	26	27	3
  2013-04-11	8	11	23	27	30	3
  2013-06-05	10	11	15	26	35	3
  2013-07-28	10	11	26	29	30	3
  2013-07-30	3	11	12	19	26	3
  2013-08-03	9	10	12	27	31	3
  2013-08-18	10	11	26	28	29	3
  2013-10-26	11	18	23	24	27	3
  2013-10-28	10	12	20	21	33	3
  2013-11-12	6	12	23	27	30	3
  2013-11-23	10	12	18	27	35	3
  2013-12-05	1	7	10	11	26	3
  2014-01-27	9	10	11	12	34	3
  2014-02-22	10	17	20	22	26	3
  2014-03-02	12	21	26	27	29	3
  2014-03-13	7	20	23	25	26	3
  2014-03-22	9	10	11	20	31	3
  2014-05-07	2	10	12	17	23	3
  2014-05-09	12	14	23	26	32	3
  2014-05-12	11	22	23	26	33	3
  2014-05-26	3	10	17	20	27	3
  2014-06-28	5	11	16	23	26	3
  2014-07-03	4	9	10	20	26	3
  2014-07-15	11	20	24	26	28	3
  2014-07-22	6	11	20	21	23	3
  2014-08-16	10	16	20	23	35	3
  2014-08-18	5	10	13	23	27	3
  2014-09-05	11	20	27	29	30	3
  2014-10-12	14	17	20	26	27	3
  2014-10-22	7	10	12	27	35	3
  2014-12-02	7	10	17	26	27	3
  2014-12-03	10	15	23	27	35	3
  2014-12-26	3	20	21	23	26	3
  2015-02-21	10	15	23	27	29	3
  2015-03-05	3	10	23	26	28	3
  2015-05-01	10	11	12	22	30	3
  2015-05-29	5	20	23	26	30	3