- Sub Macro1()
- Dim arr, brr, d, i&, s&, zf$
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a1").CurrentRegion
- [h:j].ClearContents
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- For i = 2 To UBound(arr)
- If arr(i, 1) > 103 Then
- zf = arr(i, 1) & "," & arr(i, 2)
- If Not d.exists(zf) Then
- s = s + 1
- d(zf) = s
- brr(s, 1) = arr(i, 1)
- brr(s, 2) = arr(i, 2)
- brr(s, 3) = arr(i, 3)
- Else
- brr(d(zf), 3) = brr(d(zf), 3) + arr(i, 3)
- End If
- End If
- Next
- [a1:c1].Copy [h1]
- Range("h2").Resize(s, 3) = brr
- End Sub
复制代码 |