二條件不重複 (11765)

E2:F10{=IFERROR(INDEX(A:A,SMALL(IF((MATCH($A$2:$A$99&$B$2:$B$99,$A$2:$A$99&$B$2:$B$99,)=ROW($1:$98))*($A$2:$A$99>0),ROW($2:$99)),ROW(A1))),"")

G2:J10{=INDEX($C:$C,SMALL(IF(($A$2:$A$99=$E2)*($B$2:$B$99=$F2),ROW($2:$99),4^8),COLUMN(A1)))&""



留言