Need Excel help with counting pairs

Reply #5

sar30 — Thu, 27 Mar 2008 21:00:40 GMT

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 1... [ More ]

Reply #4

sar30 — Thu, 27 Mar 2008 20:56:33 GMT

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

Reply #3

bubber58 — Thu, 27 Mar 2008 20:37:59 GMT

are there direction's for this spreadsheet

Reply #2

winsumloosesum — Thu, 27 Mar 2008 19:21:42 GMT

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.

Reply #1

winsumloosesum — Thu, 27 Mar 2008 19:17:40 GMT

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

Is this a pick 3, pick 4, ? game

Need Excel help with counting pairs

sar30 — Thu, 27 Mar 2008 16:26:34 GMT

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... [ More ]