|
我的代码:
Sub test()
Dim arr, k%, brr(), n%, d, dstr$, h%, x
arr = Range("h1").CurrentRegion
Set d = CreateObject("scripting.dictionary")
For k = 2 To UBound(arr)
dstr = arr(k, 5) & arr(k, 8)
If d.exists(dstr) = False Then
n = n + 1
d(dstr) = n
ReDim Preserve brr(1 To 3, 1 To n)
brr(1, n) = arr(k, 5)
brr(2, n) = arr(k, 8)
brr(3, n) = arr(k, 4)
Else
h = d(dstr)
brr(3, h) = brr(3, h) + arr(k, 4)
End If
Next k
Range("o1") = arr(1, 5): Range("p1") = arr(1, 8): Range("q1") = arr(1, 4)
Range("o2").Resize(UBound(brr, 2), 3) = Application.WorksheetFunction.Transpose(brr)
End Sub
应该是代码出现了问题
|
|