|
本帖最后由 ykcbf1100 于 2024-6-10 20:49 编辑
参与一下。。。- Sub ykcbf() '//2024.6.10
- Application.ScreenUpdating = False
- Set d = CreateObject("Scripting.Dictionary")
- r = Cells(Rows.Count, 1).End(3).Row
- arr = [a1].Resize(r, 3)
- For i = 2 To UBound(arr)
- s = arr(i, 1): ss = arr(i, 2)
- If Not d.exists(s) Then Set d(s) = CreateObject("Scripting.Dictionary")
- If Not d(s).exists(ss) Then
- d(s)(ss) = arr(i, 3)
- End If
- Next
- ReDim brr(1 To d.Count, 1 To 2)
- For Each k In d.keys
- m = m + 1
- brr(m, 1) = k
- brr(m, 2) = Application.Sum(d(k).items)
- Next
- [e2:f9] = ""
- [e2].Resize(m, 2) = brr
- [e2].Resize(m, 2).Borders.LineStyle = 1
- Set d = Nothing
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
3
查看全部评分
-
|