|
楼主 |
发表于 2017-2-2 19:57
|
显示全部楼层
疯哥,看到你以前帖子了,真实感动啊,原来疯哥,早已沧海难为水了。膜拜。
Sub 汇总()
Dim Arr, MyRow%, k%
Dim dic As New Dictionary
Arr = Range("A1").CurrentRegion.Value
ReDim brr(1 To UBound(Arr), 1 To 2)
For MyRow = 2 To UBound(Arr)
If Not dic.Exists(Arr(MyRow, 1)) Then
k = k + 1
dic.Add Arr(MyRow, 1), k
brr(k, 1) = Arr(MyRow, 1)
brr(dic(Arr(MyRow, 1)), 2) = brr(dic(Arr(MyRow, 1)), 2) + Arr(MyRow, 2)
Else
brr(dic(Arr(MyRow, 1)), 2) = brr(dic(Arr(MyRow, 1)), 2) + Arr(MyRow, 2)
End If
Next MyRow
Range("D2").Resize(UBound(brr), UBound(brr, 2)) = brr
End Sub |
|