Sub solution1()
Feuil1.Columns(1).RemoveDuplicates 1
End Sub
Sub solution2()
With Feuil1
For i = .Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If Application.WorksheetFunction.CountIf(.Columns(1), .Cells(i, 1)) > 1 Then
If .Rows(i).Hidden = False Then
.Cells(i, 1).Delete shift:=xlUp
End If
End If
Next i
End With
End Sub