[算表] 不同sheet比對
軟體:excel
版本:2007
想請問一下, 評審分配sheet的 G1:AL1的號碼是評審代碼
評審迴避單位sheet, 是各評審應迴避打分數的單位
想請教如何用評審分配sheet的E欄(主責單位)當KEY值
去比對評審迴避單位sheet下,各評審該迴避單位
並在評審分配sheet,在該評審代碼下打X 或 註記
檔案:http://ppt.cc/kJqq
謝謝~
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 163.15.161.248
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1396504392.A.925.html
→
04/03 14:06, , 1F
04/03 14:06, 1F
→
04/03 14:06, , 2F
04/03 14:06, 2F
→
04/03 15:13, , 3F
04/03 15:13, 3F
→
04/03 15:21, , 4F
04/03 15:21, 4F
→
04/03 15:24, , 5F
04/03 15:24, 5F
→
04/03 15:24, , 6F
04/03 15:24, 6F
→
04/03 15:27, , 7F
04/03 15:27, 7F
→
04/03 15:27, , 8F
04/03 15:27, 8F
→
04/03 17:51, , 9F
04/03 17:51, 9F
→
04/03 17:52, , 10F
04/03 17:52, 10F
→
04/03 17:54, , 11F
04/03 17:54, 11F
→
04/03 21:38, , 12F
04/03 21:38, 12F
→
04/03 22:38, , 13F
04/03 22:38, 13F
→
04/03 22:38, , 14F
04/03 22:38, 14F
→
04/03 23:04, , 15F
04/03 23:04, 15F
→
04/03 23:05, , 16F
04/03 23:05, 16F
→
04/03 23:06, , 17F
04/03 23:06, 17F
→
04/03 23:06, , 18F
04/03 23:06, 18F
→
04/03 23:31, , 19F
04/03 23:31, 19F
→
04/03 23:31, , 20F
04/03 23:31, 20F
→
04/03 23:32, , 21F
04/03 23:32, 21F
→
04/03 23:39, , 22F
04/03 23:39, 22F
→
04/03 23:59, , 23F
04/03 23:59, 23F
→
04/04 00:06, , 24F
04/04 00:06, 24F
→
04/04 09:40, , 25F
04/04 09:40, 25F
→
04/04 09:40, , 26F
04/04 09:40, 26F
→
04/04 12:48, , 27F
04/04 12:48, 27F
→
04/04 12:49, , 28F
04/04 12:49, 28F
→
04/04 13:58, , 29F
04/04 13:58, 29F
→
04/04 13:59, , 30F
04/04 13:59, 30F
→
04/04 13:59, , 31F
04/04 13:59, 31F
→
04/04 14:00, , 32F
04/04 14:00, 32F
→
04/04 14:01, , 33F
04/04 14:01, 33F
→
04/04 15:15, , 34F
04/04 15:15, 34F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
