各組出現數字 重複數字均算 (11063)

D14:F14{=COUNT(MATCH(D3:D11&COUNTIF(OFFSET(D3,,,ROW(1:9)),D3:D11),$B3:$B10&COUNTIF(OFFSET($B3,,,ROW(1:8)),$B3:$B10),))

另解{=SUM(N($B3:$B10/1%+COUNTIF(OFFSET($B3,,,ROW(1:8)),$B3:$B10)=TRANSPOSE(D3:D11/1%+COUNTIF(OFFSET(D3,,,ROW(1:9)),D3:D11))))

另解{=SUM(ABS(COUNTIF(D3:D11,$B3:$B11)+FREQUENCY($B3:$B10,$B3:$B10)*{1,-1})/{2,-2})