出現次序 取值 (10900)

C2{=IFERROR(VLOOKUP(COUNTIF(B$2:B2,B2)&B2,IF({1,0},COUNTIF(OFFSET(E$2,,,ROW($1:$9)),E$2:E$10)&E$2:E$10,F$2:F$10),2,),"")

另解{=INDEX(F:F,SMALL(IF(E$2:E$10=B2,ROW($2:$10),99),COUNTIF(B$2:B2,B2)))&""