重复个数 (10650)

C2 {=COUNT(FIND(MID(A2,3*ROW($1:$7)-2,2),B2)/(MID(A2,3*ROW($1:$7)-2,2)<>""))

另解=SUM(N(MMULT(1-ISERR(FIND(RIGHT(ROW($100:$199),2),A2:B2)),{1;1})=2))

另解 {=COUNT(0/(FIND(TRIM(MID(SUBSTITUTE(A2," ",REPT(" ",99)),ROW($1:$9)*99-98,99)),"@"&B2)>1))

另解 {=COUNT(0/(FIND(MID(A2,3*ROW($1:$7)-2,2),"@"&B2)>1))