依出現順序取值 (9305)


E2{=INDEX(C:C,SMALL(IF(RIGHT(B$2:B$8,4)-A2=0,ROW($2:$8)),COUNTIF(A$2:A2,A2)))


留言