超過15字元 重複提取 相聚 排序 (12199)

D2:E16{=IFERROR(INDEX(A:A,RIGHT(SMALL(IF((COUNTIF($A:$A,"*"&$A$2:$A$1999)>1)*($A$2:$A$1999<>""),MATCH($A$2:$A$1999,$A:$A,)*10^6+$B$2:$B$1999*10^4+ROW($2:$1999)),ROW(A1)),4)),"")