Sub Macro1()
Range("A2").Select
While ActiveCell.Value <> ""
While ActiveCell.Value <> ""
If ActiveCell.Value = ActiveCell.Offset(0, 2).Value Then
If ActiveCell.Offset(0, 1).Value <= ActiveCell.Offset(0, 3).Value Then
Range(ActiveCell, ActiveCell.Offset(0, 1)).Delete shift:=xlToLeft
Else
Range(ActiveCell.Offset(0, 2), ActiveCell.Offset(0, 3)).Delete shift:=xlToLeft
End If
End If
ActiveCell.Offset(0, 2).Select
Wend
ActiveCell.Offset(0, 2).Select
Wend
End Sub