|
发表于 2017-6-28 11:13
|
显示全部楼层
本楼为最佳答案
idno朋友这段时间在钻研字典,我就用字典做一个吧。
- Sub aaa()
- Dim arr, i&, d As Object, brr, r&
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets(2).[a1].CurrentRegion
- For i = 1 To UBound(arr)
- d(arr(i, 1)) = arr(i, 2)
- Next i
- arr = Sheets(1).[a1].CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 2)
- For i = 1 To UBound(arr)
- If Not IsNumeric(d(arr(i, 1))) Then
- r = r + 1
- brr(r, 1) = d(arr(i, 1))
- d(arr(i, 1)) = r
- End If
- brr(d(arr(i, 1)), 2) = brr(d(arr(i, 1)), 2) + arr(i, 2)
- Next i
- [e1].Resize(r, 2) = brr
- End Sub
复制代码 |
|