[算表] EXCEL~~A欄比對B欄數字~~
軟體:EXCEL
版本:2010
想請問各版友
我有個數據~例如
A欄 B欄
201502250000 201502260000
201502250005 201502260005
201502250010 201502260010
201502250020 201502260025
201502250025 201502260030
201502250030 201502260035
只是打個大概類似這樣..資料是很多的
想請問版友
要用什麼公式能快速比對出B欄沒出現的0020?
因為資料很多希望版友能幫幫忙~~~
拜託了謝謝:)
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 123.195.169.92
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1425560858.A.228.html
→
03/06 00:14, , 1F
03/06 00:14, 1F
→
03/06 00:21, , 2F
03/06 00:21, 2F
→
03/06 12:44, , 3F
03/06 12:44, 3F
→
03/06 13:06, , 4F
03/06 13:06, 4F
→
03/06 13:06, , 5F
03/06 13:06, 5F
→
03/06 18:52, , 6F
03/06 18:52, 6F
→
03/06 18:53, , 7F
03/06 18:53, 7F
→
03/06 18:54, , 8F
03/06 18:54, 8F
→
03/06 18:55, , 9F
03/06 18:55, 9F
→
03/06 18:56, , 10F
03/06 18:56, 10F
→
03/06 22:08, , 11F
03/06 22:08, 11F
→
03/06 22:08, , 12F
03/06 22:08, 12F
→
03/06 22:28, , 13F
03/06 22:28, 13F
※ 編輯: tonyflower1 (123.195.169.92), 03/06/2015 22:32:34
→
03/06 22:33, , 14F
03/06 22:33, 14F
→
03/06 22:34, , 15F
03/06 22:34, 15F
→
03/06 22:36, , 16F
03/06 22:36, 16F
→
03/06 22:37, , 17F
03/06 22:37, 17F
→
03/06 22:37, , 18F
03/06 22:37, 18F
→
03/06 22:52, , 19F
03/06 22:52, 19F
→
03/07 00:35, , 20F
03/07 00:35, 20F
→
03/07 00:37, , 21F
03/07 00:37, 21F
→
03/07 00:38, , 22F
03/07 00:38, 22F
→
03/07 00:38, , 23F
03/07 00:38, 23F
→
03/07 00:41, , 24F
03/07 00:41, 24F
→
03/07 00:43, , 25F
03/07 00:43, 25F
→
03/07 00:44, , 26F
03/07 00:44, 26F
→
03/07 00:58, , 27F
03/07 00:58, 27F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
