|
- Sub tt()
- Set d = CreateObject("scripting.dictionary")
- arr = [a1].CurrentRegion: k = 1
- ReDim brr(2 To UBound(arr), 1 To UBound(arr, 2))
- For i = 2 To UBound(arr)
- x = Trim(arr(i, 1))
- If Not d.exists(x) Then
- k = k + 1
- d(x) = k
- brr(k, 1) = x
- End If
- For j = 2 To UBound(arr, 2)
- brr(d(x), j) = brr(d(x), j) + arr(i, j)
- Next
- Next
-
- Cells(i + 1, 1).Resize(1, UBound(arr, 2)) = Application.Index(arr, 1)
- Cells(i + 2, 1).Resize(k, UBound(arr, 2)) = brr
- End Sub
复制代码 |
|