- Sub qcw()
- Dim i%, j%, arr, d As Object
- arr = [a1].CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- For i = 1 To UBound(arr)
- d(arr(i, 1) & vbTab & arr(i, 2)) = d(arr(i, 1) & vbTab & arr(i, 2)) + arr(i, 3)
- Next
- Columns("A:C").ClearContents
- [a1].Resize(d.Count) = WorksheetFunction.Transpose(d.keys)
- [c1].Resize(d.Count) = WorksheetFunction.Transpose(d.items)
- [a:a].TextToColumns
- End Sub
复制代码 |