|
- Sub Macro1()
- Dim arr, brr, d, i&, s&, n&
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("3").UsedRange
- Sheet10.Activate
- ReDim brr(1 To 1000, 1 To 13)
- For i = 2 To UBound(arr)
- If arr(i, 11) <> "" Then
- If Not d.exists(arr(i, 9)) Then
- s = s + 1
- d(arr(i, 9)) = s
- brr(s, 1) = arr(i, 9)
- brr(s, 2 + arr(i, 11)) = 1
- brr(s, 11) = brr(s, 11) + arr(i, 13)
- Else
- n = d(arr(i, 9))
- brr(n, 2 + arr(i, 11)) = 1
- brr(n, 11) = brr(n, 11) + arr(i, 13)
- End If
- End If
- Next
- [a4:m1000] = ""
- Range("a4").Resize(s, UBound(brr, 2)) = brr
- Range("a3").CurrentRegion.Sort [k4], Order1:=xlDescending, Header:=xlGuess
- End Sub
复制代码 |
|