Salut Jabsonfire,
Salut h2so4,
pas assez malin pour les formules mais en VBA, ma foi...
La macro démarre à chaque changement détecté en colonne [F] pour autant que [B] soit complété aussi.
Private Sub Worksheet_Change(ByVal Target As Range)
'
Dim iRow1%, iRow2%, iRowB%
If Not Intersect(Target, Range("F:F")) Is Nothing Then
If Range("B" & Target.Row).Value <> "" And Range("F" & Target.Row).Value <> "" And Target.Row > 1 Then
Union([A6], [A8]).Value = 0
iRowB = Range("B" & Rows.Count).End(xlUp).Row
Do
iRow1 = IIf(iRow1 = 0, 2, iRow2 + 1)
iRow2 = Range("B:B").Find(what:=Range("B" & iRow1).Value, lookat:=xlWhole, LookIn:=xlValues, searchdirection:=xlPrevious).Row
[A6] = [A6] + WorksheetFunction.Min(Range("F" & iRow1 & ":F" & iRow2))
[A8] = [A8] + WorksheetFunction.Max(Range("F" & iRow1 & ":F" & iRow2))
Loop Until iRow1 = iRowB Or iRow2 = iRowB
End If
End If
'
End Sub
A+