1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Sub test()
'on prend les 5 colonne dans une variable tableau
tableau = Range("A1:f" & Cells(Rows.Count, 1).End(xlUp).Row)
Set d = CreateObject("scripting.dictionary")
For i = LBound(tableau) To UBound(tableau)
chaine = Join(Array(tableau(i, 1), tableau(i, 2), tableau(i, 3), tableau(i, 4), tableau(i, 5)), "-")
If Not d.exists(chaine) Then
d(chaine) = i
Else
d(chaine) = d(chaine) & "|" & i
End If
Next
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row
chaine = Join(Array(Cells(i, 1), Cells(i, 2), Cells(i, 3), Cells(i, 4), Cells(i, 5)), "-")
Cells(i, 6) = d(chaine)
Next
End Sub |
Partager