最大连中2次 最大连中3次 最大连中4次 最大连错2次=LOOKUP(1,0/(MMULT(ISNUMBER(FIND("@",SUBSTITUTE(CONCAT(N($D$3:$D$114=MID(G5,4,1))),REPT(1,ROW($2:$27)),"@",COLUMN($A:$F))))*1,ROW($1:$6)^0)=MID(G5,5,1)*1),ROW($2:$27))
最大连错 =LOOKUP(1,0/FIND("0"&REPT(1,ROW($1:$27))&"0",CONCAT(N($D$3:$D$114=MID($G13,4,1)))),ROW($1:$27))
最小连中 最小连错 =MATCH(1=1,ISNUMBER(FIND("0"&REPT(1,ROW($1:$27))&"0",CONCAT(N($D$3:$D$114=MID($G21,4,1))))),0)
H列顺序一样=SUM(IFERROR(FIND("0@0","0"&SUBSTITUTE(CONCAT(N($D$3:$D$114=MID($G5,4,1))),REPT(1,$G6),"@",COLUMN($A:$F)))+2,0))&"行到"&SUM(IFERROR(FIND("0@0","0"&SUBSTITUTE(CONCAT(N($D$3:$D$114=MID($G5,4,1))),REPT(1,$G6),"@",COLUMN($A:$F)))+1,0))+$G6&"行"
=FIND("0"&REPT(1,G14)&"0",CONCAT(N($D$3:$D$114=MID($G13,4,1))))+3&"行到"&FIND("0"&REPT(1,G14)&"0",CONCAT(N($D$3:$D$114=MID($G13,4,1))))+3+G14-1&"行"
=INDEX(FIND("0"&REPT(1,ROW($1:$27))&"0",CONCAT(N($D$3:$D$114=MID($G11,4,1))))+3,G12)&"行"&REPT("到",N(G12-1>0))&REPT(INDEX(FIND("0"&REPT(1,ROW($1:$27))&"0",CONCAT(N($D$3:$D$114=MID($G11,4,1))))+3,G12)+G12-1,N(G12-1>0))&REPT("行",N(G12-1>0))三键