|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub tongji()
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a2").CurrentRegion
- brr = Range("g1").CurrentRegion
- For i = 2 To UBound(arr)
- Key = arr(i, 1) & arr(i, 2)
- If Not d.exists(Key) Then
- d(Key) = arr(i, 3)
- Else
- d(Key) = d(Key) + arr(i, 3)
- End If
- Next
- For j = 3 To UBound(brr)
- For k = 2 To UBound(brr, 2)
- brr(j, k) = d(brr(j, 1) & brr(2, k))
- Next
- Next
- Range("g1").CurrentRegion = brr
- Application.ScreenUpdating = True
- Application.DisplayAlerts = True
- End Sub
复制代码 |
|