Welcome Guest
Log In | Register )
You last visited January 18, 2017, 5:17 pm
All times shown are
Eastern Time (GMT-5:00)

Need Excel help with counting pairs

Topic closed. 5 replies. Last post 9 years ago by sar30.

Page 1 of 1
PrintE-mailLink
Avatar

United States
Member #48158
December 12, 2006
32 Posts
Offline
Posted: March 27, 2008, 12:26 pm - IP Logged

I am trying to figure out how toget excel to count pairs for me no matterif it is 13 or 31.

 

11  21
12  31
13  41
14  51
15  61
16  71
17  81
18  91
19  32
22  42
23  52
24  62
25  72
26  82
27  92
28  02
29  43
20  53
33  63
34  73
35  83
36  93

 

How many boxes with the numbers 1 and 2 or 6 and 2 exct....

 

thank you in advance

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5396 Posts
    Offline
    Posted: March 27, 2008, 3:17 pm - IP Logged

    I am trying to figure out how toget excel to count pairs for me no matterif it is 13 or 31.

     

    11  21
    12  31
    13  41
    14  51
    15  61
    16  71
    17  81
    18  91
    19  32
    22  42
    23  52
    24  62
    25  72
    26  82
    27  92
    28  02
    29  43
    20  53
    33  63
    34  73
    35  83
    36  93

     

    How many boxes with the numbers 1 and 2 or 6 and 2 exct....

     

    thank you in advance

    How many past draws are you analyzing? (100, 200, ?)

    Is this a pick 3, pick 4, ? game?

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5396 Posts
      Offline
      Posted: March 27, 2008, 3:21 pm - IP Logged

      Here is a link to a Florida Pick 3 game in Excel.

      You will need to change the draw history for your particular state. 

       http://www.badongo.com/file/5538615

      There are Pairs charts in the various tabs.

        bubber58's avatar - lol

        United States
        Member #3094
        December 23, 2003
        1059 Posts
        Offline
        Posted: March 27, 2008, 4:37 pm - IP Logged

        are there direction's for this spreadsheet?

          Avatar

          United States
          Member #48158
          December 12, 2006
          32 Posts
          Offline
          Posted: March 27, 2008, 4:56 pm - IP Logged

          This is pick but would like it for pick 4 also.

            Avatar

            United States
            Member #48158
            December 12, 2006
            32 Posts
            Offline
            Posted: March 27, 2008, 5:00 pm - IP Logged

            This isthe spread sheet: I have the pick 3 pairs set up and the repeaters but wouldlike to have excel count the pairs for me so I do not need todo by hand. Would like to know how to get the pick4 pairs calculated aslo.

             

             

              Draw  Repeaters  Pairs   
                         
              4577  455747PairsTotalPairsTotalPairsTotal 
              1788  177818112102034 
              864    866484120372041 
              101    100111130382051 
              666    666666140393062 
              719    711979150304873 
              8358  833585160442975 
              889    888989172454071 
              446    444646185463983 
              119    111919193472081 
              230    233020220482091 
              818    811888231493773 
              250    255020240401886 
              7848  788474251551801 
              87585877585260560990 
              855    855585272572000 
              066    066606281584     
              343    344333291591     
              776    777676202501     
              3543  355434332665     
              9339  933393345673     
              6969  699666353681     
              7977  799777361692     
              7637  766373
              727    722777          Repeaters
              043    0443030/1
              4599  4559491/0
              982    9882922/0
              435    4335453/1
              8888  8888884/0
              3800  3880305/1
              970    9770906/0
              188    1888187/3
              9449  9444948/5
              397    3997379/4