=MAX(EQUIV(1;DECALER(H$7;;;EQUIV(0;$A:$A;0)-7);0)-1;EQUIV(0;$A:$A;0)-1-MAX((DECALER(H$7;;;EQUIV(0;$A:$A;0)-7)=1)*LIGNE(INDIRECT("7:"&EQUIV(0;$A:$A;0)-1)));MIN(GRANDE.VALEUR(DECALER(H$7;;;EQUIV(0;$A:$A;0)-7)*LIGNE(INDIRECT("7:"&EQUIV(0;$A:$A;0)-1));LIGNE(INDIRECT("1:"&SOMME((DECALER(H$7;;;EQUIV(0;$A:$A;0)-7)=1)*1))))-GRANDE.VALEUR(DECALER(H$7;;;EQUIV(0;$A:$A;0)-7)*LIGNE(INDIRECT("7:"&EQUIV(0;$A:$A;0)-1));LIGNE(INDIRECT("2:"&SOMME((DECALER(H$7;;;EQUIV(0;$A:$A;0)-7)=1)*1)+1)))-1))
=(GRANDE.VALEUR(DECALER(H$7;;;EQUIV(0;$A:$A;0)-7)*LIGNE(INDIRECT("7:"&EQUIV(0;$A:$A;0)-1));1)-GRANDE.VALEUR(DECALER(H$7;;;EQUIV(0;$A:$A;0)-7)*LIGNE(INDIRECT("7:"&EQUIV(0;$A:$A;0)-1));2)-1)