3 lottery to find out how long it has been since a lottery number hit

[jorel]

3 lottery to find out how long it has been since a lottery number hit at positon1 (A2) position 2 (B2) & position 3 (C2) and I have also included a column beginning with (D2) that will tell me how long it has been since a number hit @ any position
https://www.excelforum.com/attachmen...1&d=1581082305

[jorel]

each day new draws will be placed within the 30 draws, that is, update, so the macro has to do automatic when changing for new pick3 in the list

[Kaper]

Try such code:

Please Login or Register  to view this content.

[jorel]

hello thanks for viewing the post but we have a problem, the digit 9 is present in the 1st position 4 times and the macro shows once, can you fix it?

[jorel]

hello,KAPER,please the digit, zero (0) appears 3 times in the 1st position, but it is marked 12
* can you fix?

[Kaper]

Show expected results. In my opinion calculation works perfect. See schematic picture

[davsth]

in b2 copy to d11
=IFERROR(MATCH($A2,L$2:L$31,0),"not found")
in e2
=MIN(B2:D2) and copy down

or if(MIN(B2:D2)=0,"not found",MIN(B2:D2))

[jorel]

the KAPER macro must count each time each of the 10 digits was drawn separately, for example the digit 9 was drawn 4 in the column or 1st position, and the table shows one, it is not pairs of digits but each
* separate

[Kaper]

Don't write description only. Show expected results in the attachment

[jorel]

Digit @ Pos 1 @ Pos 2 @ Pos 3 @ Any Pos
0 3 5 4 12 corret

[jorel]

why 12 in digit zero is in the 1st position? the correct of 12 and in any position the sum of all positions, the value is inverted the value of 12 is in all positions ie its sum of the three positions

[Kaper]

For this question "why 12 in digit zero is in the 1st position? the correct of 12 and in any position the sum of all positions, the value is inverted the value of 12 is in all positions ie its sum of the three positions" my answer was already published on the picture.
Haven't you understand it?



This:

Digit @ Pos 1 @ Pos 2 @ Pos 3 @ Any Pos
0 3 5 4 12 corret

is an answer to question: how many occurences of given digit are in columns 1, 2, 3 and in all columns together.
it is something totally different than (from your first post)

how long it has been since a lottery number hit at positon1

use in B2:

Please Login or Register  to view this content.

and copy the cell to whole B2:D11 range
in E2:

Please Login or Register  to view this content.

and copy down.

For any future question: In sample file always provide not only data, but also at least few expected results.

[jorel]

ok ,KAPER, IS CORRECT,conglatulations, thank you!