|
本帖最后由 dsmch 于 2015-8-15 15:16 编辑
- Sub Macro1()
- Dim arr, brr, d, i&, j%
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a1").CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- p = ""
- For j = 2 To UBound(arr, 2)
- p = p & "," & arr(i, j)
- Next
- If Not d.exists(p) Then d(p) = i Else d(p) = d(p) & "," & i
- brr(i, 1) = p
- Next
- For i = 1 To UBound(brr)
- brr(i, 1) = d(brr(i, 1))
- Next
- Cells(1, UBound(arr, 2) + 2).Resize(UBound(brr)) = brr
- End Sub
复制代码 |
|