Welcome Guest
You last visited April 25, 2018, 1:58 pm
All times shown are
Eastern Time (GMT-5:00)

# Need Excel help with counting pairs

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

 Page 1 of 1

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

Pennsylvania
United States
Member #2218
September 1, 2003
5799 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....

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

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

Pennsylvania
United States
Member #2218
September 1, 2003
5799 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.

There are Pairs charts in the various tabs.

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?

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.

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 457 7 45 57 47 Pairs Total Pairs Total Pairs Total 178 8 17 78 18 11 2 10 2 03 4 864 86 64 84 12 0 37 2 04 1 101 10 01 11 13 0 38 2 05 1 666 66 66 66 14 0 39 3 06 2 719 71 19 79 15 0 30 4 87 3 835 8 83 35 85 16 0 44 2 97 5 889 88 89 89 17 2 45 4 07 1 446 44 46 46 18 5 46 3 98 3 119 11 19 19 19 3 47 2 08 1 230 23 30 20 22 0 48 2 09 1 818 81 18 88 23 1 49 3 77 3 250 25 50 20 24 0 40 1 88 6 784 8 78 84 74 25 1 55 1 80 1 875 8 5 87 75 85 26 0 56 0 99 0 855 85 55 85 27 2 57 2 00 0 066 06 66 06 28 1 58 4 343 34 43 33 29 1 59 1 776 77 76 76 20 2 50 1 354 3 35 54 34 33 2 66 5 933 9 93 33 93 34 5 67 3 696 9 69 96 66 35 3 68 1 797 7 79 97 77 36 1 69 2 763 7 76 63 73 727 72 27 77 Repeaters 043 04 43 03 0/ 1 459 9 45 59 49 1/ 0 982 98 82 92 2/ 0 435 43 35 45 3/ 1 888 8 88 88 88 4/ 0 380 0 38 80 30 5/ 1 970 97 70 90 6/ 0 188 18 88 18 7/ 3 944 9 94 44 94 8/ 5 397 39 97 37 9/ 4

 Page 1 of 1