Bonjour à tous,
Je doute que ce soit aussi simple
Option Explicit
Sub test()
Dim a, i As Long, x, dico As Object
Set dico = CreateObject("Scripting.Dictionary")
dico.CompareMode = 1
With Sheets(1)
With .Range("a1", .Range("a" & .Rows.Count).End(xlUp))
a = .Value
For i = 1 To UBound(a, 1)
x = Split(a(i, 1))
If Not dico.exists(x(0) & " " & x(1)) And Not dico.exists(x(1) & " " & x(0)) Then
dico(x(0) & " " & x(1)) = Empty
End If
Next
.Offset(, .Columns.Count + 1).Resize(dico.Count).Value = Application.Transpose(dico.keys)
End With
End With
End Sub
Ne compter pas sur moi pour manipuler les chaines de caractères
klin89