|
- Sub test()
- Dim arr, k%, d As Object
- arr = Range("a1:b" & Cells(Rows.Count, 1).End(3).Row)
- Set d = CreateObject("scripting.dictionary")
- For k = 2 To UBound(arr)
- If d.exists(arr(k, 1)) = False Then
- d(arr(k, 1)) = arr(k, 2)
- End If
- Next
- Range("d1").Resize(d.Count, 1) = Application.Transpose(d.keys)
- Range("f1").Resize(d.Count, 1) = Application.Transpose(d.items)
- End Sub
复制代码 |
|