排序 字母優先 數字次之 (10541)


E2:G16{=INDEX(A:A,RIGHT(SMALL(CODE($B$2:$B$16)/1%%+$C$2:$C$16/1%+ROW($2:$16),ROW(A1)),2))


J2:L16{=INDEX(A:A,RIGHT(SMALL(CODE($B$2:$B$16)/1%%-$C$2:$C$16/1%+ROW($2:$16),ROW(A1)),2))


留言