Sub trouver()
derligne = Range("A" & Rows.Count).End(xlUp).Row
trio1 = Range("K2") & "-" & Range("L2") & "-" & Range("M2")
trio2 = Range("K2") & "-" & Range("M2") & "-" & Range("L2")
trio3 = Range("L2") & "-" & Range("K2") & "-" & Range("M2")
trio4 = Range("L2") & "-" & Range("M2") & "-" & Range("K2")
trio5 = Range("M2") & "-" & Range("L2") & "-" & Range("K2")
trio6 = Range("M2") & "-" & Range("K2") & "-" & Range("L2")
For i = 2 To derligne
test = Range("B" & i) & "-" & Range("C" & i) & "-" & Range("D" & i)
If test = trio1 Or test = trio2 Or test = trio3 Or test = trio4 Or test = trio5 Or test = trio6 Then Range("F" & i) = Range("F" & i) + 1
Next i
End Sub
Sub trouver()
derligne = Range("A" & Rows.Count).End(xlUp).Row
trio = Range("K2") & "-" & Range("L2") & "-" & Range("M2") & "*" & Range("K2") & "-" & Range("M2") & "-" & Range("L2") & "*" & _
Range("L2") & "-" & Range("K2") & "-" & Range("M2") & "*" & Range("L2") & "-" & Range("M2") & "-" & Range("K2") & "*" & _
Range("M2") & "-" & Range("L2") & "-" & Range("K2") & "*" & Range("M2") & "-" & Range("K2") & "-" & Range("L2") & "*"
For i = 2 To derligne
If InStr(trio, Range("B" & i) & "-" & Range("C" & i) & "-" & Range("D" & i) & "*") > 0 Then Range("F" & i) = Range("F" & i) + 1
Next i
End Sub