|
本帖最后由 pengyx 于 2016-4-12 17:38 编辑
Function pengyx(ss As String)'用法“=pengyx(a1)”
Set d = CreateObject("scripting.dictionary")
a = Len(ss)
ReDim ar(1 To a, 1 To 2)
For i = 1 To a
t = Mid(ss, i, 1)
r = d(t)
If r = "" Then
s = s + 1
d(t) = s
ar(s, 1) = t
ar(s, 2) = 1
Else
ar(r, 2) = ar(r, 2) + 1
End If
Next
For j = 1 To s
For k = j + 1 To s - 1
If ar(k, 2) > ar(j, 2) Then
x1 = ar(k, 1): x2 = ar(k, 2)
ar(k, 1) = ar(j, 1): ar(k, 2) = ar(j, 2)
ar(j, 1) = x1: ar(j, 2) = x2
End If
Next
tt = tt & ar(j, 1)
Next
pengyx = tt
End Function
|
|