英文尺碼大小排序 (12436)

B2{=INDEX(A:A,RIGHT(SMALL(RIGHT(SMALL(IF(ISERR(FIND(TRANSPOSE(D$2:D$6),A$2:A$10)),,{1,2,3,4,5})+ROW($2:$10)/1%,ROW($1:$9)*5),2)/1%+ROW($2:$10),ROW(A1)),2))



留言