F2:H10 {=IFERROR(INDEX(B:B,RIGHT(SMALL(IF(MATCH($C$2:$C$16&$D$2:$D$16,$C$2:$C$16&$D$2:$D$16,)<>ROW($1:$15),MATCH($C$2:$C$16,$C:$C,)/1%+ROW($2:$16)),ROW(A1)),2)),"")
另解 {=IFERROR(INDEX(B:B,RIGHT(SMALL(IF(COUNTIFS(OFFSET($C$2,,,ROW($1:$15)),$C$2:$C$16,OFFSET($D$2,,,ROW($1:$15)),$D$2:$D$16)>1,MATCH($C$2:$C$16,$C:$C,)/1%+ROW($2:$16)),ROW(A1)),2)),"")
留言
張貼留言