|
发表于 2016-12-29 18:54
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim arr, brr, d, i&, j%
- Set d = CreateObject("scripting.dictionary")
- arr = [a3:g12]
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- For i = 1 To UBound(arr)
- zf = arr(i, 2) & "," & arr(i, 3)
- If Not d.exists(zf) Then
- s = s + 1
- d(zf) = s
- brr(s, 1) = s
- For j = 2 To UBound(arr, 2)
- brr(s, j) = arr(i, j)
- Next
- Else
- n = d(zf)
- brr(n, 4) = brr(n, 4) + arr(i, 4)
- brr(n, 6) = brr(n, 6) + arr(i, 6)
- End If
- Next
- [a3:g12] = ""
- Range("a3").Resize(s, UBound(brr, 2)) = brr
- [a3:a12].SpecialCells(xlCellTypeBlanks).EntireRow.Delete
- End Sub
复制代码 |
评分
-
查看全部评分
|