排序數字優先 再按出现顺序 (9438)

C2:D20{=INDEX(A:A,RIGHT(LARGE($B$2:$B$20/1%%+(99-MATCH($A$2:$A$20,$A:$A,))/1%+ROW($B$2:$B$20),ROW(A1)),2))

另解=LOOKUP(1,0/(LARGE($B$2:$B$20+1/ROW($2:$20),ROW(A1))=$B$2:$B$20+1/ROW($2:$20)),A$2:A$20)