数字出现数 (10800)

J2:M8{=COUNT(MATCH(MID(B2,{1,2},1)&IF(LEFT(B2)=RIGHT(B2),{1,2},{1,1}),MID($A2,{1;2;3},1)&MMULT((MID($A2,{1,2,3},1)=MID($A2,{1;2;3},1))*({1;2;3}>={1,2,3}),{1;1;1}),))

G2:G8=SUMPRODUCT(N(J2:M2=2))

無輔助{=SUM(N(MMULT({1,1},1-ISNA(MATCH(IF({1;0},LEFT(B2:E2)&1,RIGHT(B2:E2)&(RIGHT(B2:E2)=LEFT(B2:E2))+1),MID($A2,{1;2;3},1)&MMULT((MID($A2,{1,2,3},1)=MID($A2,{1;2;3},1))*({1;2;3}>={1,2,3}),{1;1;1}),)))=2))