也来一个分类汇总
Sub tesss()
Dim arr, brr, crr, i, j, Im, dic
irow = Range("g65536").End(xlUp).Row
arr = Range("g4:j" & irow)
Set dic = CreateObject("scripting.dictionary")
For i = 1 To UBound(arr)
u = arr(i, 1) & arr(i, 2)
If u <> "" Then
If Not dic.exists(u) Then
dic(u) = Array(arr(i, 1), arr(i, 2), arr(i, 3), arr(i, 4))
Else
dic(u) = Array(arr(i, 1), arr(i, 2), dic(u)(2) + arr(i, 3), dic(u)(3) + arr(i, 4))
End If
End If
Next i
Im = dic.items
r = [m65536].End(3).Row
Range("m4:p" & r).ClearContents
For j = 1 To dic.Count
Cells(j + 3, "m").Resize(, 4) = Im(j - 1)
Next j
Range("m4:p" & r).Sort [m4], 1, , [n4], 1 '重新排序
End Sub |