相同数值个数 (10626)

 

C2=COUNT(0/(MMULT(1-ISERR(FIND(TEXT(ROW($1:$10),REPT(0,ISTEXT(A2)+1)),A2:B2)),{1;1})=2))

另解=COUNT(0/(MMULT(1-ISERR(FIND(TEXT(ROW($1:$10),IF(ISERR(-A2),0&0,0)),A2:B2)),{1;1})=2))