Private Sub CommandButton1_Click()
Sheet1.UsedRange.Copy [a5]
For Each rng1 In Range("a5").CurrentRegion
s = rng1.Value
ads = rng1.Address
For Each rng2 In Range("a5").CurrentRegion
If rng2.Value = s And rng2.Address <> ads Then
rng2.Delete Shift:=xlToLeft
End If
Next
Next
End Sub