|
发表于 2014-11-25 08:36
|
显示全部楼层
本楼为最佳答案
Sub Macro1()
Dim arr, d, i&, j%
Set d = CreateObject("scripting.dictionary")
arr = Range("b1").CurrentRegion
For i = 1 To 11
d("'" & Format(i, "00")) = 0
Next
For i = 1 To UBound(arr)
x = Split(arr(i, 1))
For j = 0 To UBound(x)
d("'" & x(j)) = d("'" & x(j)) + 1
Next
Next
[d23:n23] = d.keys
[d24:n24] = d.items
[D23:N24].Sort [d24], Order1:=xlDescending, Header:=xlGuess, Orientation:=xlLeftToRight
[d24:n24] = ""
End Sub
|
|