|
- Private Sub CommandButton1_Click()
- Dim ar, br, str As String, d As Object, i, j, r As String
- Set d = CreateObject("Scripting.Dictionary")
- ar = Sheet1.Range("A1").CurrentRegion
- ReDim br(1 To UBound(ar), 1 To 4)
- For i = 2 To UBound(ar)
- str = ar(i, 1) & "|" & ar(i, 2) & "|" & ar(i, 3)
- If Not d.Exists(str) Then
- Cnt = Cnt + 1
- d(str) = Cnt
- For j = 1 To 3
- br(Cnt, j) = ar(i, j)
- Next j
- End If
- r = d(str)
- If ar(i, 4) <> "" Then br(r, 4) = Round(br(r, 4) + ar(i, 4))
- Next i
- With Sheet2
- .Rows("2:1048576").Delete Shift:=xlUp
- .Cells(2, 1).Resize(Cnt, 4) = br
- End With
- End Sub
复制代码
求和.rar
(21.78 KB, 下载次数: 2)
|
评分
-
查看全部评分
|