|
Sub test2()
Dim A, d, i, j
Sheets(2).Activate
i = Cells(Rows.Count, "e").End(3).Row
If i < 2 Then End
Sheets(1).Activate
A = Range("a1:e" & Cells(Rows.Count, 1).End(3).Row)
Set d = CreateObject("scripting.dictionary")
For j = 1 To UBound(A, 2) Step 2
For i = 2 To UBound(A)
d(A(i, j)) = ""
Next i
Next j
j = 0
Sheets(2).Activate
A = Range("e1").CurrentRegion
For i = 2 To UBound(A)
If d.exists(A(i, 1)) = False Then d(A(i, 1)) = "": j = j + 1: A(j, 1) = A(i, 1)
Next i
[g:g] = ""
[g1].Resize(j) = A
End Sub
求快速查找2.rar
(18.76 KB, 下载次数: 3)
|
|