excel formula ? to show what number came out after a winning number

Reply #18

SergeM — Fri, 29 Jun 2012 20:30:34 GMT

HTML = SPACE nbsp

Reply #17

LottoBoner — Thu, 28 Jun 2012 22:22:10 GMT

good gosh serge

Reply #16

Ricklou — Thu, 28 Jun 2012 22:04:06 GMT

Hi CARBOB

I am not an excel bofin like urself but can you please be so kind to forward me above formula in a excelsheet. I am playing lotto 49/6 and I am exactly after this =also i need the Due skips and Hits and Med

Thanks very much for any help

Reply #15

SergeM — Sat, 23 Jun 2012 09:50:53 GMT

I have a similar function:

R:22 49 63

R:2 64

R:47 63 65

R:25 66 74

R:54 67

R:3 68

R:32 69 75

R:3 34 59 70

R:59 71

R:8 22 72 75

R:5 7 9 38 48 54 67 73

R:66 74

R:2 3 19 22 56 72 75

R:13 20 76

R:26 40 44 49 53 71 77

You want:

1 2

2 3

3 5

4 10

5 6

6 4

7 10

8 10

9 1

10 21

11 10

12 10

13 1

R: 8 12

Reply #14

SergeM — Sat, 23 Jun 2012 09:47:01 GMT

Put your function next to the outer right column, like told above.

If you want a list, you need to add a column for concatenation.

Maybe there is a complicated array function for this, I don't go that far because I use the VBE.

So, yes, it is possible.

Reply #13

Lucky5of5 — Sat, 23 Jun 2012 08:47:25 GMT

Gee, I'm sorry, but none of these suggestions sounds like the info I'm looking for. I'm not interested in pick 3, skips, hits, avg, med, max, due, odd/even, or frequency. Let me rephrase what I'm wanting, hope that Excel can perform it, and someone knows how to get the results for me.

Winning Lotto numbers are in numerical order, with numbers in their respective columns. If I want to search the 2nd number column for the number/value contained in the next cell directly below a given number/val... [ More ]

Reply #12

SergeM — Fri, 22 Jun 2012 20:49:52 GMT

s 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 G.O.

1 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 0 5 5 1 3 0

2 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 1 9 0 4 0 1

3 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 0 8 3

4 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 19

5 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 4 10 5

6 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 0 1

7 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 5 0 0 6 0 2

8 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 7 10

9 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 2 2

Reply #11

SergeM — Fri, 22 Jun 2012 20:46:58 GMT

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39

N N N N 0 N N N N 0 N N 0 N N N N N N N N N N N N 0 N N N N N N N 0 N N N N N

N 0 N N -1 N N N N -1 N N 0 0 N N N N N N N N N N N -1 N N 0 N N N 0 -1 N N N N N

0 -1 N 0 -2 N N N N -2 N N -1 -1 N N N N N N N N N N N -2 N N -1 N N N -1 -2 0 0 N N 0

0 0 N -1 -3 N 0 0 N -3 N N -2 -2 N N N N N N N N N N N -3 N 0 -2 N N N -2 -3 -1 -1 N N -1

-1 -1 N -2 -4 N -1 -1 N -4 N N... [ More ]

Reply #10

SergeM — Fri, 22 Jun 2012 20:40:55 GMT

N LAST DIGIT GROUP O/E FREQ. SKIPS ACTUAL HIGH SKIP DUE H.S.

1 1 0 ODD 6 2,0,5,5,1,3 0 -5 -

2 2 0 EVEN 6 1,1,9,0,4,0 -1 -9 0,11

3 3 0 ODD 3 8,0,8 -3 -8 0,38

4 4 0 EVEN 1 2 -19 -19 1,00

5 5 0 ODD 3 4,10 -5 -10 0,50

6 6 0 EVEN 2 19,0 -1 -19 0,05

7 7 0 ODD 6 3,5,0,0,6,0 -2 -6 0,33

8 8 0 EVEN 2 3,7 -10 -10 1,00

9 9 0 ODD 3 8,2,2 -7 -8 0,88

10 0 10 EVEN 3 9,3 -7 -9 0,78

11 1 10 ODD 6 7,3,2,0,3,1 0 -7 -

12 2 10 EVEN 3 5,2,3 -9 -9 1,00

13... [ More ]

Reply #9

CARBOB — Fri, 22 Jun 2012 20:35:32 GMT

You will need to sort the draws, new to old, for formulas to work correct.

Reply #8

LottoBoner — Fri, 22 Jun 2012 20:27:33 GMT

good gosh carbob

Reply #7

Lucky5of5 — Fri, 22 Jun 2012 20:03:38 GMT

Using just a short span of winning numbers here, rather than all of them:

5/31/12 == 5 10 13 26 34

6/1/12 == 2 13 14 29 33

6/2/12 == 1 4 35 36 39

6/3/12 == 1 2 7 8 28

6/4/12 == 13 16 17 19 34

6/5/12 == 5 12 32 33 39

6/6/12 == 13 20 25 31 38

6/7/12 == 11 15 16 21 38

6/8/12 == 3 9 12 27 35

6/9/12 == 1 3 7 17 20

6/10/12 == 7 10 20 24 38

6/11/12 == 7 8 9 11 35

6/12/12 == 12 17 18 31 36

6/13/12 == 2 24 26 28 29

6/14/12 == 2 9 10 11 26

6/15/12 == 1 11 20... [ More ]

Reply #6

CARBOB — Fri, 22 Jun 2012 20:01:13 GMT

Is this what you are looking for? LDP1= Last draw p1; NDP= next draw p1' you will have to do this for each postion.

formula in Hits column= change the ranges for your workbook.

=SUMPRODUCT(--('HOT-COLD'!$B$8:$B$4000=$AF$7),--('HOT-COLD'!$B$9:$B$4001=$AG7))

formula for skips, enter as array formula, Ctrl-Shift-Enter!!!

=CHOOSE(IF(N($AH7),IF(COLUMNS($AM7:AM7)=1, 1, IF(COLUMNS($AM7:AM7) =$AH7,2,3)),3),SMALL(IF('HOT-COLD'!$B$8:$B$4000 @ 'HOT-COLD'!$B$9:$B$4001=$AF$7 @ $AG7,ROW('HOT-COLD... [ More ]

Reply #5

SergeM — Fri, 22 Jun 2012 18:51:42 GMT

My data input above was wrong above, but the functions work. It was my exercise file.

I need a break from this.

Reply #4

jeankedemetser — Fri, 22 Jun 2012 18:24:10 GMT

Topic sounds nice...

Reply #3

SergeM — Fri, 22 Jun 2012 14:55:42 GMT

PICK3 BE

COUNT: TRAILER T/F BY LINE

N\T 0 1 2 3 4 5 6 7 8 9

0 215 238 197 212 209 215 204 214 198 218

1 217 220 246 239 221 200 223 229 231 230

2 215 220 191 226 230 208 207 206 203 239

3 201 220 203 222 230 212 225 220 230 230

4 204 251 198 208 190 239 212 229 229 232

5 209 230 194 212 200 192 222 214 219 205

6 175 210 226 213 221 215 224 215 221 245

7 221 231 234 209 225 206 225 225 233 223

8 224 209 224 229 230 202 227 235 230 201

9 245... [ More ]

Reply #2

SergeM — Fri, 22 Jun 2012 11:26:19 GMT

Let's say with a Pick 5 game, #10 fell in tonight's game in the 2nd numerical position (2nd column). What I want to find is what number came out after #10 in the 2nd position/column of all previous games.

Is there a formula I can type in to give me this info?

All I know how to do right now is to use the AutoFilter to find the dates that #10 fell in the 2nd position/column, copy the dates, then look at the whole list to see what numbers fell after the dates that #10 was drawn. I'm wondering... [ More ]

Reply #1

SergeM — Fri, 22 Jun 2012 10:51:21 GMT

There is a more complicated way.

excel formula ? to show what number came out after a winning number

Lucky5of5 — Fri, 22 Jun 2012 03:32:37 GMT

For Pick 3 or Pick 4, each digit of the winning number is in its own column.

For Pick 5 game, each of the five numbers is in its own column.

Let's say with a Pick 5 game, #10 fell in tonight's game in the 2nd numerical position (2nd column). What I want to find is what number came out after #10 in the 2nd position/column of all previous games. Is there a formula I can type in to give me this info?

All I know how to do right now is to use the AutoFilter to find the dates that #10 fell in... [ More ]