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

D2{=IFERROR(INDEX(B:B,RIGHT(SMALL(IF(B$2:B$12>0,CODE(LEFT(B$2:B$12))*10^8+MID(B$2:B$12,FIND("-",B$2:B$12)+1,9)/1%+ROW($2:$12)),ROW(A1)),2)),"")



留言