[算表] 自動排序問題
軟體:GOOGLE 試算表
版本:線上版本
原始參數如下
號碼 票數 排名
1 5 3
2 6 2
3 7 1
4 3 4
5 3 4
6 0 (空白)
7 1 6
想要用函數排成(6號零票..空白不計入排名)
排名 號碼
1 3
2 2
3 1
4 4
4 5
6 7
求解.....感恩
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 192.83.195.240
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1474269263.A.FD9.html
推
09/19 15:20, , 1F
09/19 15:20, 1F
※ 編輯: joker0511 (192.83.195.240), 09/19/2016 15:28:02
→
09/19 15:28, , 2F
09/19 15:28, 2F
→
09/19 15:28, , 3F
09/19 15:28, 3F
→
09/19 15:28, , 4F
09/19 15:28, 4F
→
09/19 15:30, , 5F
09/19 15:30, 5F
推
09/19 15:34, , 6F
09/19 15:34, 6F
→
09/19 15:34, , 7F
09/19 15:34, 7F
→
09/19 15:34, , 8F
09/19 15:34, 8F
→
09/19 15:40, , 9F
09/19 15:40, 9F
→
09/19 15:42, , 10F
09/19 15:42, 10F
→
09/19 15:44, , 11F
09/19 15:44, 11F
→
09/19 15:50, , 12F
09/19 15:50, 12F
→
09/19 15:57, , 13F
09/19 15:57, 13F
→
09/19 16:08, , 14F
09/19 16:08, 14F
→
09/19 16:08, , 15F
09/19 16:08, 15F
→
09/19 16:09, , 16F
09/19 16:09, 16F
→
09/19 16:11, , 17F
09/19 16:11, 17F
→
09/19 16:23, , 18F
09/19 16:23, 18F
→
09/19 16:23, , 19F
09/19 16:23, 19F
→
09/19 16:26, , 20F
09/19 16:26, 20F
→
09/19 16:30, , 21F
09/19 16:30, 21F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
