- Sub Macro1()
- Dim arr, d, i&
- Set d = CreateObject("scripting.dictionary")
- Sheet1.Activate
- arr = Range("a2:aa" & Range("aa65536").End(xlUp).Row)
- n = UBound(arr, 2)
- For i = 1 To UBound(arr)
- If Not d.exists(arr(i, n)) Then
- d(arr(i, n)) = arr(i, 1)
- Else
- d(arr(i, n)) = d(arr(i, n)) & "," & arr(i, 1)
- End If
- Next
- Sheet2.[a11].Resize(d.Count, 2) = Application.Transpose(Array(d.keys, d.items))
- End Sub
复制代码 |