|Posted: November 23, 2006, 10:11 pm - IP Logged|
You might consider adding a four more columns to your spreadsheet...a seperate column for each of the three boxed pairs and the fourth to perform the counts.
Do you have the digits separated by position? If so, lets assume that for the first combo you have listed (248) that the 2 is in column C and 4 is in column D and the 8 is in column E....all in the second row. Use the first row as column labels, like "date" "P1", "P2", "P3".
In column F you can enter: =SMALL(C2:E2,1)&SMALL(C2:E2,2) this will give you the "small pair" 24. You can label this column "Small" in cell F1
In column G you can enter =SMALL(C2:E2,1)&SMALL(C2:E2,3) this will give you the medium pair 28. You can label this column "Med" in cell G1
In column H you can enter =SMALL(C2:E2,2)&SMALL(C2:E2,3) this will give you the large pair 48. You can label this column "Large" in cell H1
You only have to enter these formulas in the first three cells below your column labels because you can select them and fill down to your most recent drawing entry.
Now, column I will be used to perform the count. Instead of having a label in cell I1, enter "24" into the cell.
In cell I2 enter =IF(OR(VALUE(F2)=$I$1,VALUE(G2)=$I$1,VALUE(H2)=$I$1),1,"") Be sure to fill this formula all the way down to the very last draw you have entered. This searches the three boxed pairs for each drawing for the pair this is listed in cell I1.
In cell J1 enter =COUNTIF(I:I,1) This is the total count that the pair listed in I1 has hit in your list of drawings...without counting it twice within double! For example, the three boxed pairs for 272 straight will be listed as 22, 27 and 27. Only one of the 27's will be counted in the total.
Since the three boxed pairs for each drawing will always be listed from the lowest to highest digit, you will only need to search the 45 no-match pairs and the 10 doubles. For example, when counting the pair hits you will never have the pair 21, it will always be listed as 12 instead. Enter any of the 45 no-match boxed pairs in low to high order in cell I1 and its count should appear to the immediate right in cell J1. You can enter any double pairs as well.
There are other ways this can be done, but this one is pretty easy to set up.
~Probability=Odds in Motion~