Sub Macro1()
Dim O As Worksheet
Dim DL As Integer
Dim TV As Variant
Dim D As Object
Set O = Worksheets("Feuil1")
DL = O.Cells(Application.Rows.Count, "A").End(xlUp).Row
O.Columns(2).ClearContents
TV = O.Range("A1:A" & DL)
Set D = CreateObject("Scripting.Dictionary")
For I = 1 To DL
D(TV(I, 1)) = ""
Next I
O.Cells(1, "B").Resize(D.Count, 1) = Application.Transpose(D.keys)
End Sub