|
- Sub test()
- Set d = CreateObject("scripting.dictionary")
- r = Range("a1").CurrentRegion
- ReDim a(1 To UBound(r, 2), 1 To UBound(r))
- For i = 2 To UBound(r)
- For j = 3 To UBound(r, 2)
- If r(i, j) <> "" Then
- If d.Exists(r(i, j)) Then
- n = Val(d(r(i, j)))
- d(r(i, j)) = Replace(d(r(i, j)), n, n + 1, , 1) & vbTab & r(i, 2)
- Else
- d(r(i, j)) = 1 & vbTab & r(i, j) & vbTab & r(i, 2)
- End If
- End If
- Next
- Next
- With CreateObject("new:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
- .SetText Join(d.items, vbNewLine)
- .PutInClipboard
- Sheet1.Paste [a17]
- End With
- Range("a17").CurrentRegion.Offset(1).Sort [a17], 2
- End Sub
复制代码 |
|