EX=VLOOKUP(E2,{"0","7923";"1","4038";"2","1359";"3","2056";"4","1376";"5","4678";"6","5938";"7","4689";"8","0157";"9","1268"},2,)
EY=VLOOKUP(E2,{"0","4568";"1","5679";"2","4678";"3","1789";"4","0289";"5","2319";"6","2014";"7","1235";"8","2346";"9","3457"},2,)
EZ=EX&EY
上面是第一组8码 E2是个位
第二组8码
=E2分别加 0123 和 6789 组成一组8码
提取两组相同的号码
=IF(COUNT(FIND(0,EV3)*FIND(0,EZ3)),0,)&SUBSTITUTE(SUMPRODUCT(ISNUMBER(FIND(ROW($19),EV3)*FIND(ROW($19),EZ3))*ROW($19)*10^(9-ROW($19))),0,)
EV是第二组8码
验证 2012001---2012027 出2 182次 出3 92次 最大连对12,最大连错3 ,很少
中规中矩,不算很好... 最近10对9
|