in pick3 from 67% to 70% it always repeats one of the digits from the last draw to the next one, is it possible to create a filter of the 1000

[jack]

hello, in pick3 from 67% to 70% it always repeats one of the digits from the last draw to the next one, is it possible to create a filter of the 1000 pick3 using one of the three digits from the last draw? example the last draw gave 460 in the next one it gave 081 repeated the digit zero,
could give the 6 or 4, then macro or formula for
to separate from the 1000 pick3, for example I type in a field 460, the macro will separate in a list all with zero, 4 or 6 but not having the other two digits when typing the filtered pick3 cannot have zero or 6, or when marking by 6 cannot have 0 or 4 when ticking 4 cannot have 6 and zero
last draw 460
example=zero(0)= 081, 035, 809.... etc note that not 4
4= 452,853.. many
6=621,953.... many
then I will use other filters, doubts?? please

 

[Winalot2007]

Try this Jack
https://u.pcloud.link/publink/show?code=XZjqETVZrmIliYONKezil5MFQyOoXkfLGM1X

 

[Winalot2007]

Enter your 3 digits selections in cells i3, i5, i7

 

[jack]

ok!!! winalot2007, perfect, congratulations, in lotteries we have to find references, the repetition from the last draw helps a lot, thank you

 

[Winalot2007]

Jack try this Excel file for repeat digits.
https://u.pcloud.link/publink/show?code=XZJccTVZk0DMqw6XD3kGhxcWPTjtMpQiU4Iy

 

[Winalot2007]

This was shared on another lottery forum many years ago.

Example,
Just play when the current drawing is a 6-way set (123, 435, 621, etc)
1>Go to the worksheet Premio1
2>Cell J20 = 077081
3>Pick 3 = 081
4>6-way = 081
5>Write down the winning digits 0, 8, 1
6>Pairs 08, 81, 01 Box Pairs 08, 18, 01
Take the 3 digits from the last 6-way winning set (0, 8, 1)
Pick A, B, C, D, E from the chart below and create Pick 3 sets
Below I entered the digit 0 with the "A" list, digit 8 with the "C" list, and digit 1 with the "E" list.
So the sets would be as follows:
007, 017, 026, 047, 005, 024, 045, 067, 034
869, 809, 878, 859, 838, 829, 868, 816, 802
156, 146, 136, 108, 127, 148, 139, 104, 135
You can eliminate doubles from the list above.

Master Chart
0 A __ 07 17 26 47 05 24 45 67 34
B __ 01 23 19 18 14 57 15 25 79
8 C __ 69 09 78 59 38 29 68 16 02
D __ 13 49 06 37 89 12 58 03 28
1 E __ 56 46 36 08 27 48 39 04 35

 

[jack]

ok WINALOT, conglatulations, thank you!