用自定义函数吧。如下图。
用法:=CELLREPT(统计区间)
该函数区分大小写,重复的空白字符也计算在内。如需修订请追问。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/902397dda144ad34e92d0885d3a20cf431ad8526?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
Function CellRept(rng As Range) As String
Dim d, k
Set d = CreateObject("Scripting.Dictionary")
Dim rg As Range
Dim i As Integer
For Each rg In rng
For i = 1 To Len(rg)
If d.exists(Mid(rg, i, 1)) Then
d(Mid(rg, i, 1)) = d(Mid(rg, i, 1)) + 1
Else
d(Mid(rg, i, 1)) = 1
End If
Next
Next
For Each k In d.keys
If d(k) > 1 Then CellRept = CellRept & k
Next
Set d = Nothing
End Function