上下二期出現指定數字的次數 (14868)

(A:F有輸入固定數字 無須此) J2:Q2 下拉{=SMALL(IF((COUNTIF($I2:I2,ROW($1:$49))=0)*(ROW($1:$49)<=$H$2),ROW($1:$49)),RANDBETWEEN(1,$H$2-COLUMN(A1)+1))

(A:F有輸入固定數字 無須此) A2:F2 下拉=SMALL($J2:$O2,COLUMN(A1))

Q2下拉=IF(ROW(A1)>H$2,"",ROW(A1))

R1右拉=IF(COLUMN(A1)>$H2,"",COLUMN(A1))

R2右拉 下拉=TEXT(SUM(MMULT((OFFSET($A$2:$F$2,,,999)=$Q2)*(OFFSET($A$2:$F$2,,,999)<>""),{1;1;1;1;1;1})*MMULT((OFFSET($A$2:$F$2,$H$8,,999)=R$1)*(OFFSET($A$2:$F$2,$H$8,,999)<>""),{1;1;1;1;1;1})),"0;;")