|
发表于 2015-9-30 11:26
|
显示全部楼层
本楼为最佳答案
- Sub tt()
- arr = [a1].CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- x = arr(i, 1) & arr(i, 2)
- If Not d1.exists(x) Then
- d1(x) = ""
- d(arr(i, 1)) = d(arr(i, 1)) + 1
- End If
- Next
- [d2].Resize(d.Count, 2) = Application.Transpose(Array(d.keys, d.items))
- End Sub
复制代码 |
|