|
- Sub test()
- Dim r%, i%
- Dim arr, brr
- Dim d As Object
- Set d = CreateObject("scripting.dictionary")
- With Worksheets("2011")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .Range("a2:d" & r)
- End With
- For i = 1 To UBound(arr)
- d(arr(i, 1)) = d(arr(i, 1)) + arr(i, 2)
- Next
- For Each aa In d.keys
- If d(aa) = 0 Then
- d.Remove (aa)
- End If
- Next
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- m = 0
- For i = 1 To UBound(arr)
- If d.exists(arr(i, 1)) Then
- m = m + 1
- For j = 1 To UBound(arr, 2)
- brr(m, j) = arr(i, j)
- Next
- End If
- Next
- With Worksheets("结果")
- .UsedRange.Offset(1, 0).Clear
- .Range("a2").Resize(m, UBound(brr, 2)) = brr
- End With
- End Sub
复制代码 |
|