|
发表于 2017-4-26 17:01
|
显示全部楼层
本楼为最佳答案
H列先设置文本格式。
- Sub aaa()
- Dim arr, brr, i&, j&, d As Object, r&
- Set d = CreateObject("scripting.dictionary")
- arr = [a1].CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 4)
- For i = 2 To UBound(arr)
- If Not d.exists(arr(i, 1) & arr(i, 2)) Then
- r = r + 1
- d(arr(i, 1) & arr(i, 2)) = r
- For j = 1 To 3
- brr(r, j) = CStr(arr(i, j))
- Next j
- End If
- brr(r, 4) = brr(r, 4) + arr(i, 4)
- Next i
- [h2].Resize(r, 4) = brr
- End Sub
复制代码 |
|