|
发表于 2015-10-19 15:49
|
显示全部楼层
本楼为最佳答案
- Sub text()
- arr = [a1].CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- For i = 1 To UBound(arr)
- x = arr(i, 2)
- If Not d.exists(x) Then
- n = n + 1
- d(x) = n
- brr(n, 1) = n
- brr(n, 2) = x
- End If
- p = d(x)
- For j = 3 To UBound(arr, 2)
- If arr(i, j) > 0 Then brr(p, j) = brr(p, j) + arr(i, j)
- Next
- Next
- Range("h1").Resize(n, UBound(arr, 2)) = brr
- End Sub
复制代码 |
评分
-
查看全部评分
|