[問題] excel 排序問題
(若是和其他不同軟體互動之問題 請記得一併填寫)
軟體:excel
版本:office 365
請教各位高手有關excel排序問題
因為弄了一整個晚上的資料,眼睛快瞎掉了....
http://dropjar.com/#1yhnt5by
檔案如連結
D欄的size需要排序如下:
XXS
XS
S
M
L
XL
XXL
XXS
XS
S
M
L
XL
XXL
我已經在自訂排序中有自訂清單,但是排序後會變成
XXS
XXS
XXS
.
.
XS
XS
XS
.
.
.
S
S
S
.
.
M
M
.
請問大家這樣有解嗎....謝謝!謝謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 223.141.130.29
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1462376403.A.9E3.html
→
05/04 23:57, , 1F
05/04 23:57, 1F
→
05/04 23:58, , 2F
05/04 23:58, 2F
→
05/05 00:32, , 3F
05/05 00:32, 3F
→
05/05 00:46, , 4F
05/05 00:46, 4F
→
05/05 00:53, , 5F
05/05 00:53, 5F
→
05/05 00:53, , 6F
05/05 00:53, 6F
推
05/05 10:04, , 7F
05/05 10:04, 7F
推
05/05 10:06, , 8F
05/05 10:06, 8F
→
05/05 10:06, , 9F
05/05 10:06, 9F
→
05/05 10:53, , 10F
05/05 10:53, 10F
討論串 (同標題文章)
完整討論串 (本文為第 3 之 3 篇):
問題
2
10