二項重複 提出 (10222)

E2:F5{=IFERROR(INDEX(A:A,SMALL(IF((COUNTIFS($A:$A,$A$2:$A$21,$B:$B,$B$2:$B$21)>1)*(COUNTIFS($E$1:$E1,$A$2:$A$21,$F$1:$F1,$B$2:$B$21)=0),ROW($2:$21)),1)),"")

註記行於重复C2=IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2)>1,"重复","")