detect the number of times that pick3 occurred in the green list.

detect the number of times that pick3 occurred in the green list,
with the list of pick3 draws, no matter
the position, example =
012 = is the same as 210 102 201 .... the macro will see no matter the position of the 3 digits, objective
is to have on the green list the number of times each
training took place, if it is late,
remembering in the list of sweepstakes I’ll put lots of sweepstakes I’ll update every day
make automatic
https://www.excelforum.com/attachmen...1&d=1595362481

hello please

May be formula can help

Please Login or Register  to view this content.

ok BWV good job, i will post new drawings every week, will the formula be automatic?

if you have only 3 digits then you have 3!=6 combinations and the formula is ok for it.

ok my doubt is that that list of pick3 draws was an example. I will exchange the list for another
pick3 official and each week new draws will be placed the formula will make automatic ??

hello,BWV can you help me, I put new sweepstakes, (alias new sweepstakes will be placed every week and the formula is not doing when I place or change the sweepstakes, can I do it with a command to activate? please
https://www.excelforum.com/attachmen...1&d=1595714069

Bo_Ry . Hello. First of all i always glad to se your solutions. But i also try to get compromise solution between length of formulas and performance.
I compared
=SUM(COUNTIFS($B$5:$B$4000;MID(TEXT(N5;"000");{1;1;2;2;3;3};1);$C$5:$C$4000;MID(TEXT(N5;"000");{2;3;1;3;1;2};1);$D$5:$D$4000;MID(TEXT(N5;"000");{3;2;3;1;2;1};1)))
and
=SUMPRODUCT(--(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(N5;"000");$B$5:$B$4000;;1);$C$5:$C$4000;;1);$D$5:$D$4000;;1)=""))

3870 source rows and 4095 rows . The results are 3,578125 and 13,07813. So for huge data my formula is better.

Even for set from example 0,0859375 and 0,28125.

However thanks for remainder about this method.