bonjour,
une proposition de macro,
Sub aargh()
dl = Cells(Rows.Count, 1).End(xlUp).Row + 1
For i = 2 To dl
If Cells(i, 1) <> k Then
If i > 2 Then Cells(i - 1, 3) = dltf
dltf = True
k = Cells(i, 1)
End If
If i < dl Then Cells(i, 3) = False
If Application.WorksheetFunction.IsNA(Cells(i, 2)) Then dltf = False
Next i
End Sub