|
请教各位高手,要求在附件中。
- Sub Macro1()
- Dim arr, brr, w, d, i&, j%, k%
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a2").CurrentRegion
- n = UBound(arr)
- ReDim brr(1 To n, 1 To 10)
- For i = 1 To n
- s = 0
- For j = 1 To 4
- For k = j + 1 To 5
- s = s + 1
- brr(i, s) = Val(Mid(arr(i, 3), j, 1) & Mid(arr(i, 3), k, 1))
- Next
- Next
- Next
- For j = 1 To 10
- ReDim w(99)
- For i = 1 To n
- w(brr(i, j)) = n - 1 - i
- d(w(brr(i, j))) = brr(i, j)
- Next
- Cells(1001, j + 22) = Application.Max(w)
- Cells(1003, j + 22) = d(Application.Max(w))
- d.RemoveAll
- Next
- End Sub
复制代码
|
|