数字统计问题

来源:百度知道 编辑:UC知道 时间:2024/06/06 23:38:42
07, 08, 10, 11, 13, 17, 18, 19, 20, 23, 26, 27, 28, 30, 04, 06, 11, 19, 23, 28, 27, 08, 16, 18, 19, 22, 25, 26, 02, 04, 11, 12, 21, 23, 27, 04, 07, 11, 19, 20, 23,
27, 04, 10, 19, 22, 23, 26, 27, 08, 16, 18, 19, 22, 25, 26, 02, 04, 11, 12, 21, 23, 27, 04, 07, 11, 19, 20, 23, 27, 04, 10, 19, 22, 23, 26, 27, 18, 05, 14, 19, 20,
22, 11, 12, 17, 18, 24, 25, 26, 30, 05, 10, 14, 18, 19, 20, 22, 30, 02, 06, 13, 19, 21, 24, 27, 05, 11, 13, 16, 21, 26, 28, 04, 10, 13, 21, 22, 23, 24, 10, 19, 21,
22, 26, 28, 29, 02, 06, 13, 15, 16, 21, 22, 02, 04, 05, 06, 08, 10, 11, 13, 14, 15, 16, 19, 21, 22, 23, 24, 26, 27, 28, 29, 07, 08, 09, 13, 15, 25, 26, 09, 12, 18,
19, 20, 25, 30, 02, 06, 09, 11, 13, 25, 26, 02, 07, 11, 15, 18, 20, 30, 02, 07, 12, 13, 20, 26, 30, 02, 06, 07, 09, 15, 20, 25, 02, 06, 07, 08, 13, 15, 20, 06, 08,
09, 12, 13, 15, 25, 06, 08, 09, 11, 12, 13, 25, 02, 08, 11, 13, 15, 25, 30, 05, 12, 14, 16, 17, 24, 26, 04, 09, 10, 14, 19, 22, 29, 01, 14, 15, 21, 23, 26,

哎 没必要弄的那么复杂 利用WORD的文档形式可以很简单的解决这一问题
你先把要查找的数字全部复制到WORD文档里 然后CTRL+F(查找和替换)就可以了 然后分别出现了查找 替换 定位 3个标签,你切换到替换那一页 查找内容后面输入你要查的数字 替换后面输入同样的数字 再点全部替换 WORD会自动提示你做了多少处替换
这样 你对原来的数据没有做任何的修改 但就很简单的知道了他出现的次数了 几秒就可以查出任一数字出现的次数
比如07一共出现了23 次 08是16次 10是15次 11是32次 13是34次。。。

用查找功能,选中全部查找你须要的数字,就知道有多少个你查的数字了

--A------B------C
1 01 =COUNTIF(数据存放区域,A1)
2 02 =COUNTIF(数据存放区域,A2)
3 03 =COUNTIF(数据存放区域,A3)
.. ... .......
48 48 =COUNTIF(数据存放区域,A48)

呵呵 我和你说最简单的办法啊
不用什么数字统计器,你把这些数字都输入到excel里,在编辑栏点击查找,输入01查找,他就会统计处01出现了多少次,只不过这样你就必须一个一个的统计,虽然麻烦,但比较简单。