三欄重複 相聚取出 (13852)

E2:G12{=IFERROR(INDEX(A:A,RIGHT(SMALL(IF(COUNTIFS($A:$A,$A$2:$A$20,$B:$B,$B$2:$B$20,$C:$C,$C$2:$C$20)>1,MATCH($A$2:$A$20,$A:$A,)/1%+ROW($2:$20)),ROW(A1)),2)),"")



留言