EXCEL如何统计b列中重复的身份证号码,并在c列中显示出个数
=IF(COUNTIF($B$2:B2,B2)=COUNTIF($B$2:$B$16,B2&"*"),COUNTIF($B$2:$B$16,B2&"*")-1,"")
=COUNTIF(B$2:B2,B2)
下拉填充公式
热门标签:
=IF(COUNTIF($B$2:B2,B2)=COUNTIF($B$2:$B$16,B2&"*"),COUNTIF($B$2:$B$16,B2&"*")-1,"")
=COUNTIF(B$2:B2,B2)
下拉填充公式