Share

Need pick4 excel sheet

lakerben's avatar - 4eyes

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

Avatar
In response to lakerben

Look-up

Pick 4 Excel by DiamondPalace

I believe that may have what your looking for.

 GW

lakerben's avatar - 4eyes
In response to Gwoof

Alot of his links are disabled. 

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

Avatar

 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

db101's avatar - RB55Ms1

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

lakerben's avatar - 4eyes

I'm still waiting.

 

Thud

Avatar
In response to Gwoof

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  
FreqP-4 #'s 
361
342
353
394
235
226
277
188
109
0110

 

POS 2  
FreqP-4 #'s 
511
372
363
204
295
286
247
158
029
0310

 

POS 3  
FreqP-4 #'s 
571
502
323
354
285
196
147
068
039
0110

 

POS 4  
FreqP-4 #'s 
531
342
303
384
225
166
197
158
179
0110

 

The formula works for any number of games.

  GW

Avatar

Same formula only it's for last 10 games.

   LAST 10 GAMES           
POS 1   POS 2   POS 3   POS 4  
FreqP-4 #'s  FreqP-4 #'s  FreqP-4 #'s  FreqP-4 #'s 
351 311 401 381
292 282 372 232
123 263 123 143
164 194 154 104
145 105 145 195
176 146 066 126
107 027 037 157
038 058 088 078
089 079 099 069
0110 0310 0110 0110

  GW

winsumloosesum's avatar - Lottery-060.jpg
In response to lakerben
lakerben's avatar - 4eyes
In response to winsumloosesum

Thanks steve!!!!

TopEnd of thread (1 page)

Welcome Guest

Your last visit: Wed, Dec 2, 2020, 3:59 pm

Log In

Log InCancel

Forgot your username?

Forgot your password?