Sub sup()
With ActiveSheet
Derlign = .Range("A65000").End(xlUp).Row
.Range("A1:C" & Derlign).Sort Key1:=Range("A2"), Order1:=xlAscending, _
Key2:=Range("B2"), Order2:=xlAscending, Header:=xlGuess
For i = Derlign To 2 Step -1
If .Cells(i, 1) = .Cells(i - 1, 1) And .Cells(i, 2) = .Cells(i - 1, 2) Then
.Range(.Cells(i, 1), .Cells(i, 2)).ClearContents
End If
Next
End With
End Sub