Sub NonDoublons()
Set d = CreateObject("Scripting.Dictionary")
Tbl = Range("a2:c" & [a65000].End(xlUp).Row)
For i = LBound(Tbl) To UBound(Tbl)
clé = Tbl(i, 1) & "|" & Tbl(i, 2) & "|" & Tbl(i, 3)
d(clé) = d(clé) + 1
Next i
j = 0
Dim b(): ReDim b(1 To d.Count, 1 To 3)
For Each c In d.keys
If d(c) = 1 Then
j = j + 1
a = Split(c, "|")
b(j, 1) = a(0): b(j, 2) = a(1): b(j, 3) = a(2)
End If
Next c
[e2].Resize(j, 3) = b
End Sub