[算表] 每周通訊錄製作問題請教
軟體:EXCEL
版本:03
想請教一下各位,我有一個通訊錄每月要製作,但是要看在單位人數重編,
要依照地區分組,大約5~8組較資深者為組長。
我目前是這樣子
http://ppt.cc/eCcF
請教大家,有沒有更簡單的公式?
單位有大概8~90人所以每次休假大概10~12個我必須每次找出來刪掉很麻煩,
有沒有快選單之類的?
(說明一下我那台電腦是00版所以我的IF只能8階,但我會把他更新03)
謝謝~
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.44.82.218
→
02/03 14:15, , 1F
02/03 14:15, 1F
→
02/03 14:15, , 2F
02/03 14:15, 2F
→
02/03 14:34, , 3F
02/03 14:34, 3F
→
02/03 15:56, , 4F
02/03 15:56, 4F
推
02/03 17:41, , 5F
02/03 17:41, 5F
→
02/03 18:48, , 6F
02/03 18:48, 6F
→
02/03 21:33, , 7F
02/03 21:33, 7F
→
02/04 13:35, , 8F
02/04 13:35, 8F
→
02/04 13:35, , 9F
02/04 13:35, 9F
→
02/04 14:41, , 10F
02/04 14:41, 10F
→
02/04 14:54, , 11F
02/04 14:54, 11F
→
02/04 14:55, , 12F
02/04 14:55, 12F
→
02/04 14:56, , 13F
02/04 14:56, 13F
→
02/04 15:02, , 14F
02/04 15:02, 14F
→
02/04 15:10, , 15F
02/04 15:10, 15F
→
02/04 15:11, , 16F
02/04 15:11, 16F
→
02/04 15:48, , 17F
02/04 15:48, 17F
→
02/04 15:52, , 18F
02/04 15:52, 18F
→
02/04 15:52, , 19F
02/04 15:52, 19F
→
02/04 16:02, , 20F
02/04 16:02, 20F
→
02/04 16:07, , 21F
02/04 16:07, 21F
→
02/04 16:07, , 22F
02/04 16:07, 22F
→
02/04 16:32, , 23F
02/04 16:32, 23F
→
02/04 16:35, , 24F
02/04 16:35, 24F
→
02/04 16:46, , 25F
02/04 16:46, 25F
→
02/04 16:48, , 26F
02/04 16:48, 26F
→
02/04 18:00, , 27F
02/04 18:00, 27F
→
02/04 21:35, , 28F
02/04 21:35, 28F
→
02/04 21:35, , 29F
02/04 21:35, 29F
→
02/06 20:43, , 30F
02/06 20:43, 30F
→
02/06 20:43, , 31F
02/06 20:43, 31F
→
02/07 01:50, , 32F
02/07 01:50, 32F
→
02/08 17:39, , 33F
02/08 17:39, 33F
→
02/08 17:43, , 34F
02/08 17:43, 34F
→
02/09 14:41, , 35F
02/09 14:41, 35F
→
02/09 14:41, , 36F
02/09 14:41, 36F
→
02/09 21:27, , 37F
02/09 21:27, 37F