Welcome Guest
Log In | Register )
The time is now 5:19 am
You last visited September 2, 2014, 5:07 am
All times shown are
Eastern Time (GMT-5:00)

Excel formulas for Pick 3 & 4 help needed

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

Page 1 of 1
PrintE-mailLink
powerplayer's avatar - Lottery-022.jpg

United States
Member #17834
June 28, 2005
2064 Posts
Offline
Posted: November 24, 2005, 2:00 am - IP Logged

Hello All,


I have a formula =SUM(ISNUMBER(FIND("520",B3:AE21))*1) that I use in excel. It's able to take a and find one # for either pick 3 or 4 across all parts of a excel sheet. I have been doing this formula for all combinations to see what is coming out the most. This is good for straights I figure or even boxes to narrow things down.

My question I have is  1. Does any one know how to expand this formula to be able to search all combinations at once? I know there are like 24 combo's just for a easy 1234 pick 4 # and 6 for pick 3. The pick 3 I'm doing prettty good on and have done almost all 1,000 combinations ...yes this was a lot of work!!! for all of mid-day draw in November. I want to make this formula do more so I can do less manually. I need the formula to search for all 6 or 3 combo's for pick 3 and then well if this can be done then the pick 4 will be a snap!!

I did make one formula:

=SUM(ISNUMBER(FIND("123",B3:S21))*1,ISNUMBER(FIND("132",B3:S21))*1,ISNUMBER(FIND("213",B3:S21))*1,ISNUMBER(FIND("231",B3:S21))*1,ISNUMBER(FIND("312",B3:S21))*1,ISNUMBER(FIND("321",B3:S21))*1)

This one can do all 6 combinatons at once but, ever time I save and then reopen excel it doesn't seem to save the location it searches. So all my work is being done and then gone in a matter of seconds when I close excel.

 

Any help would be great!!

Below is a example of the way I chart my pick 3 for mid-day only!! I don't do seperate cells in excel I put all 3 digits in one cell. Not sure if this is harder but, from what I can see from othe people they track 1 number per cell.

Good till 11/21/05 did get a chance to update fully yet.

Also below this is a list of what I have been able to get for best combo's hitting so far across all states. I'm only listing a couple because to long to paste.

State11/1/0511/2/0511/3/0511/4/0511/5/0511/6/0511/7/0511/8/0511/9/0511/10/0511/11/0511/12/0511/13/0511/14/0511/15/0511/16/0511/17/0511/18/0511/19/0511/20/0511/21/05
Month of November 2005
California Mid-Day 4:00pm063519076437  162187971238847213  261  430  613  193657  649464  161  079  495  296
Connecticut Mid-Day 1:57 pm411566832798  n/an/a047673411325  527  n/an/a718307904208018n/an/a245
DC Mid-Day 1:45 pm337497610112  743125073685734317  785897370702959  022785  992  682  275615
Deleware Mid-Day 1:25 pm417951647130  390n/a731009235322  240  604  n/a958688  590786  249  900  n/a103 
Georgia Mid-Day 12:14236804626052  347n/a888197196523  175  285  n/a405184  377286  965  747  n/a197 
Illinois & Iowa Mid-Day 1:25 & 1:20780080519276  350n/a123752121488  780  756  n/a995696  959519  150  053n/a984 
Indiana Mid-Day 1:00834629468508  795n/a829890863920  709  350  n/a928658  929002  888  719  n/a304
Kentucky Mid-Day 1:10544310317985  889n/a963239624020  862  451  n/a563312  063710  381  355  n/a110 
Maryland Mid-Day 12:13  399563246695  501396193109168003  767  835  477  611734  880481  703  911  444  242 
Michigan Mid-Day 12:24816565639052  673845212801167508  382  524  312  326  550  992448  631  391  028  675
Missouri Mid-Day 1:40529155623851  027990336317067787  466  460  755  955  079  105759  763  011  918  922 
New Jersey Mid-Day 12:40894559472431  811152097702721470  902  460  181  425  352  569785  609  059  461  438 
New York Mid-Day 12:10501019640509  411185619060043199  667  772  589  713  197  459467  074  105  742  385 
Ohio Mid-Day 12:14977325753150  891n/a089297088924  331  351  n/a582  892  656769  856  770  n/a751
Pennsylvania Mid-Day 12:50302157733359  567644664117882482  364  769  251  379  125  416656  188  724  476331 
South Carolina Mid-Day 12:30925106884259  304n/a321156508254  208  129  n/a261  505  602142  716  483  n/a785 
Texas Mid-Day 1:00365042177535  138n/a439122575324  956  244  n/a453  048  606047  290  074  n/a  641 
Tri-State Mid-Day 12:50586598198159  415889417659683771  670  676  178  194  011  537841  247628  653  824 
Virginia Mid-Day 1:38949220074620284n/a945569662299  604  761  n/a465490800248  156  306  n/a678


 

 

1231
1320
2131
2310
3122
3211
Total

5

1370
1730
3173
3710
7131
7311
Total5

 

2680
2861
6281
6821
8260
8621
Total4


0472
0743
4070
4701
7040
7400
Total6


 

0150
0510
1052
1502
5012
5100
Total6


This seems like the best double so far: ( I believe it came out today 11/23/05...not updated on this)

5671
5760
6571
6751
7561
7650
Total4


Enjoy all


Powerplayer

Good luck to everyone!!!

    hypersoniq's avatar - xls
    Pennsylvania
    United States
    Member #1340
    April 6, 2003
    2444 Posts
    Offline
    Posted: November 24, 2005, 1:26 pm - IP Logged

    not sure why it isn't saving, but in the interim, you should copy and paste your most used formulas (that won't save) into a notepad .txt file and just paste them back in when working with the excel file.

    Playing more than one ticket per game is betting against yourself.

      lottaloot's avatar - AvatarZ56
      Redford/MI
      United States
      Member #3396
      January 18, 2004
      4867 Posts
      Offline
      Posted: November 24, 2005, 2:02 pm - IP Logged

      Powerplayer, are you trying to search for

      ex: all ways of 123

      123,132,213,231,312,321

      if so, you might want to just have a formula within your spreadsheet that changes your draw results into the boxed format within a second column---that way you can search for the number in boxed format.

      L ttaL   T

        Tenaj's avatar - michellea
        Charlotte NC
        United States
        Member #17406
        June 18, 2005
        4036 Posts
        Offline
        Posted: November 24, 2005, 2:10 pm - IP Logged

        Powerplayer, are you trying to search for

        ex: all ways of 123

        123,132,213,231,312,321

        if so, you might want to just have a formula within your spreadsheet that changes your draw results into the boxed format within a second column---that way you can search for the number in boxed format.

        Lottaloot, will you give us those two formulas?

        takeemtothebank

          powerplayer's avatar - Lottery-022.jpg

          United States
          Member #17834
          June 28, 2005
          2064 Posts
          Offline
          Posted: November 24, 2005, 2:33 pm - IP Logged

          Yes Lottoloot that is excatly what I'm trying to do except not by box by best combination hitting so I can narrow down which combo hit more and what would be a good straight.

          So for example:

          0472
          0743
          4070
          4701
          7040
          7400
          Total6


           

          This # has been hot across the states.6 hits in 21 days. Not bad!! Remeber this is mid-day only.

          So I know now that 074 seems to be a good way to play the # but, also 704 and 740 have not come out yet across states. See where I'm going with this. So if I bet 074 straight 047 and 470 I figure I have a better chance of winning on those combo's in that order.

          For box it doesn't matter but, you can also play 3 of the 6 combo's and if it hits well triple your money. Same goes with straight.

          Even doing this with one state works really well but, out of the 6 hits this month up till the 21st I have hit on this # 4 TIMES by doing this.


          I'm playing the hot combo. It's a new way for me not sure if any one else has tried this.

          If I can keep my formula with the right location to look at with out it changing every time I close excel it would be a lot easier to keep track.

          The formula I had up above =SUM(ISNUMBER(FIND("123",B3:S21))*1,ISNUMBER(FIND("132",B3:S21))*1,ISNUMBER(FIND("213",B3:S21))*1,ISNUMBER(FIND("231",B3:S21))*1,ISNUMBER(FIND("312",B3:S21))*1,ISNUMBER(FIND("321",B3:S21))*1)

           

          Does the 123 as a example in all combinations but, it doesn't stick with the location. It changes depending on what cell I have it in.

          Thank you for you help


          Powerplayer

           

          Time for dinner. I hope I don't miss to much while I'm gone.


           

           

          Good luck to everyone!!!

            CARBOB's avatar - FL LOTTERY_LOGO.png
            ORLANDO, FLORIDA
            United States
            Member #4924
            June 3, 2004
            4191 Posts
            Online
            Posted: November 24, 2005, 6:13 pm - IP Logged

            powerplayer,

              I hope I understand your question.  $B17:$B3992 = COLUMN WHERE list of draws are, AT18 = Combo you're searching for. Enter fomula in cell next to the combo you're searching for, then drag& fill the other 5 cells.

            Carbob

             

            =COUNTIF($B$17:$B$3992,AT18)

             

            0473
            0743
            4703
            4073
            7405
            7043


              powerplayer's avatar - Lottery-022.jpg

              United States
              Member #17834
              June 28, 2005
              2064 Posts
              Offline
              Posted: November 24, 2005, 6:52 pm - IP Logged

              Thank you Carbob. I will try this tonight at work.

              Looking foward to getting this done.


              Powerplayer

              Good luck to everyone!!!