5,139
社区成员
发帖
与我相关
我的任务
分享
Sub GetSums()
Dim Dic As Object, Arr, Ary, k%
Arr = Range("A2", [A65536].End(3)(1, 3))
Set Dic = CreateObject("Scripting.Dictionary")
For k = 1 To UBound(Arr)
If Not Dic.exists(Arr(k, 2)) Then
Ary = Array(Arr(k, 2), Arr(k, 3), Arr(k, 3))
Else
Ary = Dic(Arr(k, 2))
Ary(1) = Ary(1) & "/" & Arr(k, 3)
Ary(2) = Ary(2) + Arr(k, 3)
End If
Dic(Arr(k, 2)) = Ary
Next
Sheets(2).[A1].Resize(1, 3) = Array("续保人", "续保金额", "总额")
For Each itm In Dic
Sheets(2).[A65536].End(3)(2).Resize(1, 3) = Dic(itm)
Next
Set Dic = Nothing
End Sub