二項取單一 (15011)

B C欄不重複 F2:G16{=INDEX(B:B,SMALL(IF(MATCH($B$2:$B$24&$C$2:$C$24,$B$2:$B$24&$C$2:$C$24,)=ROW($1:$23),ROW($2:$24),99),ROW(A1)))&""

H2:H16=IF(F2="","",SUMIFS(D:D,B:B,F2,C:C,G2))