[算表] 檢查重複數值
軟體:excel
版本:2013
假設目前有個表格:
1 2 3 4 5 6
A B C D E F
D F E E W A
A E E R V W
C F W Q E R
如果想要一次分別檢查所有資料,
把每一行相同的數值都抓出來,
該怎麼設定?
比方第一行 A D A C 就把兩個重複的A標出來
第二行 B F E F 把兩個重複的F抓出來。
常用 > 設定格式化的條件
這裡好像每次都要選取檢查範圍
這樣的話如果有六行就要重複六次一樣的動作
想請教有沒有一次檢查六行的方法?
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.38.96.91
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1436912333.A.F45.html
→
07/15 07:15, , 1F
07/15 07:15, 1F
→
07/15 22:01, , 2F
07/15 22:01, 2F
→
07/15 23:02, , 3F
07/15 23:02, 3F
→
07/15 23:51, , 4F
07/15 23:51, 4F
→
07/15 23:52, , 5F
07/15 23:52, 5F
→
07/16 11:14, , 6F
07/16 11:14, 6F
→
07/16 11:16, , 7F
07/16 11:16, 7F
→
07/16 11:17, , 8F
07/16 11:17, 8F
→
07/16 11:20, , 9F
07/16 11:20, 9F
→
07/16 11:32, , 10F
07/16 11:32, 10F
→
07/16 11:32, , 11F
07/16 11:32, 11F
→
07/16 11:35, , 12F
07/16 11:35, 12F
→
07/16 11:36, , 13F
07/16 11:36, 13F
→
07/16 11:38, , 14F
07/16 11:38, 14F
→
07/16 11:40, , 15F
07/16 11:40, 15F
→
07/16 11:41, , 16F
07/16 11:41, 16F
→
07/16 11:45, , 17F
07/16 11:45, 17F
→
07/16 11:45, , 18F
07/16 11:45, 18F
→
07/16 11:46, , 19F
07/16 11:46, 19F
→
07/16 11:46, , 20F
07/16 11:46, 20F
→
07/16 11:48, , 21F
07/16 11:48, 21F
→
07/16 11:49, , 22F
07/16 11:49, 22F
→
07/16 11:49, , 23F
07/16 11:49, 23F
→
07/16 11:51, , 24F
07/16 11:51, 24F
→
07/16 11:51, , 25F
07/16 11:51, 25F
→
07/16 11:54, , 26F
07/16 11:54, 26F
→
07/16 11:54, , 27F
07/16 11:54, 27F
→
07/16 12:03, , 28F
07/16 12:03, 28F