excel表格如何快速查重复次数

'自定义公式-按ALT+F11-插入模块-粘贴代码-将表格另存为启用宏的格式Function 去重显示次数(a As Range, c As String, d As String)For Each cel In a b = b & " " & celNextArr = Split(Mid(b, 2), " ")Set dic = CreateObject("dictionary")For i = 0 To UBound(Arr) dic(Arr(i)) = dic(Arr(i)) + 1Next n = keys m = ItemsIf c = 1 Then 去重显示次数 = n(d - 1)Else 去重显示次数 = m(d - 1)End IfEnd Function

用countif函数语法结构：COUNTIF(range,create)。理解为：COUNTIF（统计区域，查找的内容）例如：目标单元格中输入公式：=COUNTIF(D:D,"男")或=COUNTIF(C:C,">59")

已经有代码一键完成了，只是被隐藏私用了。

不清楚你是否需要这种格式