|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub Test()
- Dim d As Object, d1, ar, br, k, i&, m%, n%
- Set d = CreateObject("Scripting.Dictionary")
- Set d1 = CreateObject("Scripting.Dictionary")
- ar = Sheets("sheet1").UsedRange
- For i = 2 To UBound(ar)
- If Not d.Exists(ar(i, 2)) Then
- d(ar(i, 2)) = ""
- End If
- Next
- ReDim br(1 To d.Count, 1 To UBound(ar))
- For Each aa In d.keys
- k = k + 1
- n = 1
- For i = 2 To UBound(ar)
- If ar(i, 2) = aa Then
- If Not d1.Exists(ar(i, 5)) Then
- d1(ar(i, 5)) = ""
- n = n + 1
- br(k, 1) = ar(i, 2)
- br(k, n) = ar(i, 5)
- End If
- End If
- Next
- Next
- Sheets("sheet1").Range("p1").Resize(d.Count, UBound(br, 2)) = br
- End Sub
复制代码 |
|