What excel array formula...

Reply #8

Sunglasses — Thu, 17 Nov 2016 19:02:25 GMT

A 1 2 3 4 0 1 2 3 4 5 6 7 8 9 T D

0123 0 1 2 3 1 1 1 1 0 0 0 0 0 0 - -

0235 0 2 3 5 1 0 1 1 0 1 0 0 0 0 - -

1245 1 2 4 5 0 1 1 0 1 1 0 0 0 0 - -

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

Reply #7

Sunglasses — Thu, 17 Nov 2016 18:50:34 GMT

A 0123

B 0235

C 1245

= A Intersect B Intersect C

Reply #6

dr san — Thu, 17 Nov 2016 16:45:37 GMT

hello sumglass ex= pick4

0123

0235

1245

Reply #5

adulane62 — Thu, 17 Nov 2016 15:29:19 GMT

Thanks, Winsum! The first one is what i was looking for.

Reply #4

Sunglasses — Thu, 17 Nov 2016 12:24:08 GMT

A B C 0 1 2 3 4 5 6 7 8 9 T

3 1 2 - - - - - - - - - - -

3 2 2 0 0 1 1 0 0 0 0 0 0 2

Matrix

Reply #3

winsumloosesum — Thu, 17 Nov 2016 09:33:46 GMT

For Pick 3 and numbers games

Where my winning number for Pick 3 start on line 20 in cell range G20:I20. Previous/older draws are below line 20

This formula will count how many digits repeated from the previous drawing. Since Pick 3 game can have repeating digits (doubles triples) use the formula below

=SUMPRODUCT(IF(COUNTIF($G20:$I20,{0,1,2,3,4,5,6,7,8,9}) COUNTIF($G21:$I21,{0,1,2,3,4,5,6,7,8,9}),COUNTIF($G20:$I20,{0,1,2,3,4,5,6,7,8,9}),COUNTIF($G21:$I21,{0,1,2,3,4,5,6,7,8,9})))

Adju... [ More ]

Reply #2

winsumloosesum — Thu, 17 Nov 2016 09:24:35 GMT

If you want to calculate how many numbers repeated from the previous drawing:

My 5/30 game entries start on line 20. My cash 5 draws are entered E20:I20

This formula is just for the previous drawing only

=MIN(IF(COUNTIF(E20:I20,E21) 0,1)+IF(COUNTIF(E20:I20,F21) 0,1)+IF(COUNTIF(E20:I20,G21) 0,1)+IF(COUNTIF(E20:I20,H21) 0,1)+IF(COUNTIF(E20:I20,I21) 0,1),IF(COUNTIF(E21:I21,E20) 0,1)+IF(COUNTIF(E21:I21,F20) 0,1)+IF(COUNTIF(E21:I21,G20) 0,1)+IF(COUNTIF(E21:I21,H20) 0,1)+IF(COUNTIF(G21:I21,I2... [ More ]

Reply #1

winsumloosesum — Thu, 17 Nov 2016 09:02:35 GMT

My 5 most recent draws for the PA530 Treasure Hunt Game are always entered on line 20 (E20:I20)

So if I wanted to Sum how many numbers repeated after the current drawing on line 20 I would use the following formula:

The formula below will count how many numbers repeated from the next 5 drawings.

After you enter the formula below use control +shift+enter (Ctrl-Shift-Enter)

You should see the brackets { } at each end of the formula

=SUM(IF(COUNTIF(E21:I25,E20:I20) 0,1,0

What excel array formula...

adulane62 — Thu, 17 Nov 2016 06:55:31 GMT

...should I use to see if any of the numbers from the latest draw matched from the previous (i.e., preceding) five draws? I know there is countif, index or match involved, however in what order? Thanks