按次序排列 同名相聚 (11787)

(先)R2:S16{=INDEX(F:F,RIGHT(SMALL(MATCH($F$2:$F$16,$B:$B,)/1%+ROW($2:$16),ROW(A1)),2))

(後)N2:O16=IF($R1<>$R2,VLOOKUP($R2,$B:$C,COLUMN(A1),1),"")