|
- Sub t1()
- Dim ar, br, i%, j%, d As Object
- Set d = CreateObject("scripting.dictionary")
- ar = Worksheets("T3").Range("a1").CurrentRegion
- ReDim br(1 To UBound(ar, 1), 1 To UBound(ar, 2))
- With Worksheets("t3")
- For i = 6 To UBound(ar)
- If Not d.exists(ar(i, 1)) Then
- j = j + 1
- d(ar(i, 1)) = j
- br(j, 1) = ar(i, 1)
- End If
- Next i
- For i = 1 To d.Count
- For j = 1 To UBound(ar)
- If br(i, 1) = ar(j, 1) Then
- br(i, 2) = br(i, 2) + ar(j, 2)
- br(i, 3) = br(i, 3) + ar(j, 3)
- br(i, 4) = br(i, 4) + ar(j, 4)
- End If
- Next j
- Next i
- .[f6].Resize(UBound(br, 1), UBound(br, 2)) = br
- End With
- Set d = Nothing
- End Sub
复制代码
請您把小單位匯總的工作表名稱改為T3,繁簡緣故,我的代碼無法呈現簡體
看看這樣是不是您要的結果 |
评分
-
查看全部评分
|