排序 先字母順序 (15267)

E2:F16{=INDEX(B:B,RIGHT(SMALL(IF(LENB(LEFT($C$2:$C$16))=1,CODE(LEFT($C$2:$C$16)),MATCH($C$2:$C$16,$C:$C,)/1%)/1%+ROW($2:$16),ROW(A1)),2))