|
- Sub test()
- Dim d, d2, arr, i%, n%, r%
- Dim brr(1 To 100, 1 To 2)
- Set d = CreateObject("scripting.dictionary")
- arr = Range("d2:f" & Cells(Rows.Count, 4).End(3).Row)
- For i = 1 To UBound(arr)
- If d.Exists(arr(i, 1)) Then
- r = d(arr(i, 1))
- brr(r, 2) = brr(r, 2) + arr(i, 3)
- Else
- d(arr(i, 1)) = i
- brr(i, 1) = arr(i, 1)
- brr(i, 2) = arr(i, 3)
- End If
- Next
- Range("n2").Resize(i, 2) = brr
- End Sub
复制代码 大神写的代码 |
|