編號數個 出現者均提取 且依序相同相聚 (13782)

H2:K9{=IFERROR(INDEX(A:A,RIGHT(SMALL(IF(COUNTIF($F:$F,$A$2:$A$16),MATCH($A$2:$A$16,$F:$F,)/1%+ROW($2:$16)),ROW(A2)),2)),"")