[請問] excel編班
各位大大,有強者可以教我寫公式,我要根據報讀者的交表順序給編排,各班限額一百,
以收表順序去決定報讀者的首選次選及第三選,如:當班別a滿了,就讀次選,當次選也
滿就選第三選
,令它自動按交表序號填入各人可讀班別。是用if(countif....嗎? 表格如下,謝謝
解答
交表序號 首選 次選 第三
1 a b c
2 b a c
3 b a d
--
Sent from my Android
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 27.109.160.101
※ 文章網址: https://www.ptt.cc/bbs/ask/M.1441639357.A.77D.html
→
09/07 23:35, , 1F
09/07 23:35, 1F
→
09/07 23:52, , 2F
09/07 23:52, 2F
→
09/07 23:52, , 3F
09/07 23:52, 3F
→
09/07 23:57, , 4F
09/07 23:57, 4F
→
09/07 23:58, , 5F
09/07 23:58, 5F
推
09/08 00:15, , 6F
09/08 00:15, 6F
→
09/08 00:18, , 7F
09/08 00:18, 7F
→
09/08 00:19, , 8F
09/08 00:19, 8F
推
09/08 00:21, , 9F
09/08 00:21, 9F
→
09/08 00:21, , 10F
09/08 00:21, 10F
→
09/08 00:22, , 11F
09/08 00:22, 11F
→
09/08 00:23, , 12F
09/08 00:23, 12F
→
09/08 00:23, , 13F
09/08 00:23, 13F
→
09/08 02:41, , 14F
09/08 02:41, 14F
→
09/08 02:43, , 15F
09/08 02:43, 15F
→
09/08 02:48, , 16F
09/08 02:48, 16F
→
09/08 02:58, , 17F
09/08 02:58, 17F
→
09/08 02:59, , 18F
09/08 02:59, 18F
→
09/08 02:59, , 19F
09/08 02:59, 19F
→
09/08 06:50, , 20F
09/08 06:50, 20F
推
09/08 10:38, , 21F
09/08 10:38, 21F