|
发表于 2013-1-13 19:52
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim A, B, d, k, t, i
- Range("A1").CurrentRegion.Sort Key1:=Range("A1"), _
- Order1:=xlAscending, _
- Key2:=Range("B1"), _
- Order2:=xlAscending, _
- Header:=xlYes
- A = Range("A2:C" & Range("A65536").End(xlUp).Row)
- Set d = CreateObject("scripting.dictionary")
- For i = 1 To UBound(A)
- d(A(i, 1)) = d(A(i, 1)) & "," & A(i, 2)
- Next i
- k = d.keys: t = d.items: Set d = Nothing
- For i = 0 To UBound(k)
- A(i + 1, 1) = k(i)
- B = Split(t(i), ",")
- A(i + 1, 2) = B(1)
- If UBound(B) > 1 Then
- A(i + 1, 3) = B(UBound(B))
- End If
- Next i
- Range("e2:g65536").ClearContents
- [e2].Resize(i - 1, 3) = A
- End Sub
复制代码
基本信息2.rar
(122.4 KB, 下载次数: 36)
|
|