|
- Sub zdy()
- Dim arr, brr, d, i%, j%, p$
- Set d = CreateObject("scripting.dictionary")
- arr = [a1:c3]
- ReDim brr(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- zf = Join(Application.WorksheetFunction.Index(arr, i, 0), "")
- brr(i, 1) = "'" & zf
- For j = 1 To UBound(arr, 2)
- d(arr(i, j)) = d(arr(i, j)) + 1
- Next
- Next
- x1 = Application.Min(d.items)
- x2 = Application.Max(d.items)
- p = "'"
- For i = 0 To 9
- If Not d.exists(i) Then p = p & i
- Next
- For i = x1 To x2
- For j = 0 To 9
- If d(j) = i Then p = p & j
- Next
- Next
- Range("a11").Resize(UBound(brr)) = brr
- [b13] = p
- End Sub
复制代码 |
评分
-
查看全部评分
|