删除重复项
Sub cfz()
Dim i&, Myr&, Arr
Dim d, k
Set d = CreateObject("Scripting.Dictionary")
Myr = Sheet1.[a65536].End(xlUp).Row
Arr = Sheet1.Range("a1:g" & Myr)
For i = 1 To UBound(Arr)
d(Arr(i, 3)) = ""
Next
k = d.keys
Sheet2.Activate
[a1].Resize(d.Count, 1) = Application.Transpose(k)
Set d = Nothing
End Sub