|
发表于 2013-6-1 09:21
|
显示全部楼层
本楼为最佳答案
- Sub aa()
- Dim i%, j%, k%, str$, arr, d As Object
- Set d = CreateObject("scripting.dictionary")
- For i = 2 To 6
- For j = 1 To 8
- str = str & Cells(i, j) & ","
- Next
- d(str) = ""
- str = ""
- Next
- For i = 8 To 12
- For j = 1 To 8
- str = str & Cells(i, j) & ","
- Next
- If Not d.Exists(str) Then
- k = k + 1
- Cells(k + 7, 11).Resize(1, 8) = Cells(i, 1).Resize(1, 8).Value
- Else
- d.Remove str
- End If
- str = ""
- Next
- arr = d.Keys
- For i = 0 To UBound(arr)
- Cells(i + 2, 11).Resize(1, 8) = Split(arr(i), ",")
- Next
- End Sub
复制代码 |
|