二項去重複 (9913)


F2:G5{=IFERROR(INDEX(A:A,SMALL(IF(($A$2:$A$16=$I$2)*(COUNTIFS($F$1:$F1,$A$2:$A$16,$G$1:$G1,$B$2:$B$16)=0),ROW($2:$16)),1)),"")


留言