- Sub 求和()
- Set d = CreateObject("Scripting.Dictionary")
- Set D1 = CreateObject("Scripting.Dictionary")
- arr = Range("A1").CurrentRegion
- For i = 2 To UBound(arr)
- D1(arr(i, 1)) = ""
- d(arr(i, 1) & arr(i, 2)) = d(arr(i, 1) & arr(i, 2)) + arr(i, 3)
- Next
- N = D1.Count
- Range("F2").Resize(N, 1) = Application.Transpose(D1.KEYS)
- Range("G1:I1") = Split("产品A,产品B,产品C", ",")
- BRR = Range("F1").Resize(N + 1, 4)
- For i = 2 To N + 1
- For j = 2 To 4
- BRR(i, j) = d(BRR(i, 1) & BRR(1, j))
- Next
- Next
- Range("F1").Resize(N + 1, 4) = BRR
- End Sub
复制代码 |