F2:I7由上往下提{=INDEX(A:A,SMALL(IF(COUNTIFS($B:$B,$B$2:$B$10,$C:$C,$C$2:$C$10)=COUNTIFS(OFFSET($B$2,,,ROW($1:$9)),$B$2:$B$10,OFFSET($C$2,,,ROW($1:$9)),$C$2:$C$10),ROW($2:$10),99),ROW(A1)))&""
由下往上提{=IFERROR(INDEX(A:A,LARGE(IF(COUNTIFS($G$1:$G1,$B$2:$B$10,$H$1:$H1,$C$2:$C$10)=0,ROW($2:$10)),1)),"")
留言
張貼留言