excel sorting 問題

[匿名]

2009-10-11 5:57 am

1......sorting code先….7x-xx
2......sorting date
3......sorting 完後,不能做倒中間紅色地方出來

http://i.imagehost.org/0865/1_5.jpg

有何方法..thank you

更新1:

please see http://i.imagehost.org/0865/1_5.jpg

回答 (1)

2009-10-11 11:15 pm

✔ 最佳答案

DATE
code
code1

code2

09/01/2009
70-21
70
=LEFT(B2,2)
21
=RIGHT(B2,2)

09/08/2009
71-03
71

03

08/29/2009
71-05
71

05

09/10/2009
71-42
71

42

08/29/2009
71-43
71

43

09/17/2009
73-07
73

07

09/08/2009
73-44
73

44

加多两欄, 將code切成2個欄(公式: "=left(field,2)" 及 "=right(field,2)" ; sort code1, 再sort date,再sort code2,
結果如下:

DATE
code
code1

code2

09/01/2009
70-21
70

21

08/29/2009
71-05
71

05

08/29/2009
71-43
71

43

09/08/2009
71-03
71

03

09/10/2009
71-42
71

42

09/08/2009
73-44
73

44

09/17/2009
73-07
73

07

👍 0 👎 0