|
本帖最后由 豆丁 于 2012-3-20 09:25 编辑
没看明白一对多是神马意思!
- Sub test()
- Dim arr, d, i%, mkey, arrt(), k%
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a1").CurrentRegion
- For i = 1 To UBound(arr)
- d(arr(i, 1) & "|" & arr(i, 2)) = d(arr(i, 1) & "|" & arr(i, 2)) + 1
- Next
- For Each mkey In d.keys
- If d(mkey) = 1 Then
- k = k + 1
- ReDim Preserve arrt(1 To 2, 1 To k)
- arrt(1, k) = Split(mkey, "|")(0)
- arrt(2, k) = Split(mkey, "|")(1)
- End If
- Next
- Range("d:e").ClearContents
- [d1].Resize(UBound(arrt, 2), 2) = WorksheetFunction.Transpose(arrt)
- End Sub
复制代码 |
|