|
干脆把所有结果给你列出来。1行字符,2行频率,3行合并,4行所有字符加频率
- Sub test()
- Set d = CreateObject("scripting.dictionary")
- arr = [a1].CurrentRegion
- For i = 1 To UBound(arr)
- For k = 1 To Len(arr(i, 1))
- d(k & Mid(arr(i, 1), k, 1)) = d(k & Mid(arr(i, 1), k, 1)) + 1
- Next
- Next
- ReDim br(1 To Len(arr(1, 1)))
- For k = 1 To Len(arr(1, 1))
- ar = Filter(d.keys, k)
- m = m + 1
- n = 0
- For Each a In ar
- If d(a) > n Then mx = d(a): n = d(a)
- br(m) = br(m) & Right(a, 1) & d(a)
- Next
- For Each a In ar
- If d(a) = mx Then st = st & Right(a, 1): srt = srt & Right(a, 1) & mx
- Next
- mst = mst & mx
- Next
- [c1] = st
- [c2] = mst
- [c3] = srt
- [c4].Resize(, m) = br
- End Sub
复制代码 |
|