Sub 删除重复()
On Error Resume Next
Dim x As Integer, r As Integer
For x = 1 To Range("a65536").End(xlUp).Row
If Cells(x, 1) = "" Then Exit Sub
r = Application.Match(Cells(x, 2), Range("b:b"), 0)
If r < x Then
If Cells(r, 8) <= Cells(x, 8) Then
Rows(x).Delete
Else
Rows(r).Delete
End If
x = x - 1
End If
Next x
End Sub