二項不重複 取出 (15049)

F2:G14{=INDEX(B:B,MIN(IF(COUNTIFS($F$1:$F1,$B$2:$B$21,$G$1:$G1,$C$2:$C$21)=0,ROW($2:$21),99)))&""

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

B2:D21格式化=($B2=$F$2)*($C2=$G$2)