|
- Sub Macro1()
- Dim arr, d, i&, j%, p$
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("a4").CurrentRegion
- For i = 1 To UBound(arr)
- p = ""
- For j = 3 To UBound(arr, 2)
- p = p & "," & arr(i, j)
- Next
- If Not d.exists(p) Then
- d(p) = i
- Else
- For j = 3 To UBound(arr, 2)
- arr(d(p), j) = ""
- arr(i, j) = ""
- Next
- End If
- Next
- Sheet2.[a4].Resize(UBound(arr), UBound(arr, 2)) = arr
- End Sub
复制代码 |
|