|
Sub test()
Set d = CreateObject("scripting.dictionary")
With Sheet2
r = .Cells(Rows.Count, 1).End(xlUp).Row
ar = .Range("a1:c" & r)
ReDim br(1 To UBound(ar), 1 To 3)
For i = UBound(ar) To 2 Step -1
If Trim(ar(i, 1)) <> "" Then
t = d(Trim(ar(i, 1)))
If t = "" Then
k = k + 1
d(Trim(ar(i, 1))) = k
t = k
br(k, 1) = ar(i, 1)
br(k, 2) = ar(i, 2)
br(k, 3) = ar(i, 3)
End If
End If
Next i
rs = .Cells(Rows.Count, 5).End(xlUp).Row + 5
.Range("e2:g" & rs) = Empty
.Range("e2").Resize(k, 3) = br
End With
End Sub
看看是不是这个意思吧?调整下对应的表 |
|