# Need pick4 excel sheet

I'd like it be able to input the last 25 draws. And be able to see how many times each number 0 to 9 has hit in each postion.

Output

P1  P2   P3  P4

0          2      1    2      0

1          3      0    0     1

2          1      3    0     0

3           4    2     1      0

4

5

6

7

8

9

Look-up

Pick 4 Excel by DiamondPalace

I believe that may have what your looking for.

GW

Alot of his links are disabled.

The reason I posted is to get a sheet like I requested.

I don't know much about excel but maybe this might help..

Taken this from "Pick 4 Excel by DiamondPalace"
Separate your 4 digit number to columns B,C,D,E

Paste this in column I 5 to I 14
=COUNTIF(\$B\$1:\$B\$20,H5)
Do the same for C,D,E in columns M,R & W or select your own columns.
Change the B to C,D & E in their pasted columns (M,R,W)

Hope it works for you

GW

I have used Boyd French's free sheets for Pick 3/4, they have lots of unlocked formulas for tracking and manipulating numbers. Even if they are not exactly what you need, if you know some Excel you can copy and paste the formulas into your own workbooks and tweak them as necessary. https://boydfrench.blogspot.com

I'm still waiting.

The above counts how many times 0 to 9 hits in each position for me for last 20 games.

Just change the 20 to 25 for 25 games.

 POS 1 Freq P-4 #'s 3 6 1 3 4 2 3 5 3 3 9 4 2 3 5 2 2 6 2 7 7 1 8 8 1 0 9 0 1 10

 POS 2 Freq P-4 #'s 5 1 1 3 7 2 3 6 3 2 0 4 2 9 5 2 8 6 2 4 7 1 5 8 0 2 9 0 3 10

 POS 3 Freq P-4 #'s 5 7 1 5 0 2 3 2 3 3 5 4 2 8 5 1 9 6 1 4 7 0 6 8 0 3 9 0 1 10

 POS 4 Freq P-4 #'s 5 3 1 3 4 2 3 0 3 3 8 4 2 2 5 1 6 6 1 9 7 1 5 8 1 7 9 0 1 10

The formula works for any number of games.

GW

Same formula only it's for last 10 games.

 LAST 10 GAMES POS 1 POS 2 POS 3 POS 4 Freq P-4 #'s Freq P-4 #'s Freq P-4 #'s Freq P-4 #'s 3 5 1 3 1 1 4 0 1 3 8 1 2 9 2 2 8 2 3 7 2 2 3 2 1 2 3 2 6 3 1 2 3 1 4 3 1 6 4 1 9 4 1 5 4 1 0 4 1 4 5 1 0 5 1 4 5 1 9 5 1 7 6 1 4 6 0 6 6 1 2 6 1 0 7 0 2 7 0 3 7 1 5 7 0 3 8 0 5 8 0 8 8 0 7 8 0 8 9 0 7 9 0 9 9 0 6 9 0 1 10 0 3 10 0 1 10 0 1 10

GW

Thanks steve!!!!