[算表] 統計每個數字出現的次數
軟體:excel
版本:2007
請教一下各位高手
在EXCEL的表格中
有622551155226、652551155256、622155551226等數百種變化的欄位
有辦法統計所有欄位加總起來
1到6號所有出現的次數嗎?
數字總共有7位數跟11位數兩種
麻煩幫忙解答 謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 111.252.201.199
→
11/11 12:39, , 1F
11/11 12:39, 1F
推
11/11 13:55, , 2F
11/11 13:55, 2F
→
11/11 14:03, , 3F
11/11 14:03, 3F
→
11/11 14:04, , 4F
11/11 14:04, 4F
→
11/11 14:12, , 5F
11/11 14:12, 5F
→
11/11 14:13, , 6F
11/11 14:13, 6F
→
11/11 14:17, , 7F
11/11 14:17, 7F
→
11/11 14:18, , 8F
11/11 14:18, 8F
→
11/11 14:21, , 9F
11/11 14:21, 9F
推
11/11 14:30, , 10F
11/11 14:30, 10F
→
11/11 17:28, , 11F
11/11 17:28, 11F
→
11/11 17:29, , 12F
11/11 17:29, 12F
→
11/11 18:32, , 13F
11/11 18:32, 13F
→
11/11 18:33, , 14F
11/11 18:33, 14F
→
11/11 18:33, , 15F
11/11 18:33, 15F
→
11/11 18:33, , 16F
11/11 18:33, 16F