如何统计excel文件中出现相同数据的次数

Question

如题所述

Answer 1

用countif函数呀，举例如下：
=countif(a1:c20,">5")
=countif(a1:c20,5)
=countif(a1:c20,a1)
=countif(a1:c20,"数学")
其用法还有很多，可以百度一下学习学习。

Answer 2

c =IF(COUNTIF($A$1:tmp,A1)>1,COUNTIF($A$1:$A$11,A1),"")
c =IF(COUNTIF($A$1:tmp,A2)>1,COUNTIF($A$1:$A$11,A2),"")
d =IF(COUNTIF($A$1:tmp,A3)>1,COUNTIF($A$1:$A$11,A3),"")
d =IF(COUNTIF($A$1:tmp,A4)>1,COUNTIF($A$1:$A$11,A4),"")
g =IF(COUNTIF($A$1:tmp,A5)>1,COUNTIF($A$1:$A$11,A5),"")
g =IF(COUNTIF($A$1:tmp,A6)>1,COUNTIF($A$1:$A$11,A6),"")
g =IF(COUNTIF($A$1:tmp,A7)>1,COUNTIF($A$1:$A$11,A7),"")
a =IF(COUNTIF($A$1:tmp,A8)>1,COUNTIF($A$1:$A$11,A8),"")
c =IF(COUNTIF($A$1:tmp,A9)>1,COUNTIF($A$1:$A$11,A9),"")
c =IF(COUNTIF($A$1:tmp,A10)>1,COUNTIF($A$1:$A$11,A10),"")
g =IF(COUNTIF($A$1:tmp,A11)>1,COUNTIF($A$1:$A$11,A11),"")
不所头疼你就研究一下吧。

Answer 3

太笼统,
是一个文件中, 还是多个?
是一个工作表,还是多个?
是在一列中, 还是多列?
是数字, 还是文字?本回答被提问者采纳

Answer 4

回答的比提问的要详细多了.