[算表] 直的排序
軟體: MS_excel
版本:2007
想請教大家每列直的排序除了一列列排之外,有任何函數可以快速達成嗎?
想要的結果如下:
A欄B欄C欄D欄 A欄B欄C欄D欄
3 2 5 9 3 2 1 6
5 8 2 8 → 5 4 2 7
9 4 6 7 7 6 5 8
7 6 1 6 9 8 6 9
謝謝大家~
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 163.15.161.248
→
12/27 15:48, , 1F
12/27 15:48, 1F
→
12/27 15:49, , 2F
12/27 15:49, 2F
→
12/27 16:41, , 3F
12/27 16:41, 3F
→
12/27 17:21, , 4F
12/27 17:21, 4F
→
12/27 17:22, , 5F
12/27 17:22, 5F
→
12/27 17:27, , 6F
12/27 17:27, 6F
→
12/27 17:28, , 7F
12/27 17:28, 7F
→
12/27 17:28, , 8F
12/27 17:28, 8F
→
12/27 17:29, , 9F
12/27 17:29, 9F
→
12/27 17:36, , 10F
12/27 17:36, 10F
→
12/27 17:49, , 11F
12/27 17:49, 11F
→
12/27 17:49, , 12F
12/27 17:49, 12F
→
12/27 17:50, , 13F
12/27 17:50, 13F