bonjour Dhany,
oui lol trop fort comme d'habitude.
j'en suis la en formule avec 2 convoyeurs mdr:
=SI(ET(I17<>0;I17<2;SOMME(I17:I18)<=2;J33<>$B$17;I33<>$B$17;K33<>$B$17;I37<>$B$17;J37<>$B$17);$B$17;
SI(ET(I18<>0;I18<2;SOMME(I18:I19)<=2;J33<>$B$18;I33<>$B$18;K33<>$B$18;I37<>$B$18;J37<>$B$18);$B$18;
SI(ET(I19<>0;I19<2;SOMME(I19:I20)<=2;J33<>$B$19;I33<>$B$19;K33<>$B$19;I37<>$B$19;J37<>$B$19);$B$19;
SI(ET(I20<>0;I20<2;SOMME(I20:I21)<=2;J33<>$B$20;I33<>$B$20;K33<>$B$20;I37<>$B$20;J37<>$B$20);$B$20;
SI(ET(I21<>0;I21<2;SOMME(I21:I22)<=2;J33<>$B$21;I33<>$B$21;K33<>$B$21;I37<>$B$21;J37<>$B$21);$B$21;
SI(ET(I22<>0;I22<2;SOMME(I22:I23)<=2;J33<>$B$22;I33<>$B$22;K33<>$B$22;I37<>$B$22;J37<>$B$22);$B$22;
SI(ET(I23<>0;I23<2;SOMME(I23:I24)<=2;J33<>$B$23;I33<>$B$23;K33<>$B$23;I37<>$B$23;J37<>$B$23);$B$23;
SI(ET(I24<>0;I24<2;SOMME(I24:I25)<=2;J33<>$B$24;I33<>$B$24;K33<>$B$24;I37<>$B$24;J37<>$B$24);$B$24;
SI(ET(I25<>0;I25<2;SOMME(I25:I25)<=2;J33<>$B$25;I33<>$B$25;K33<>$B$25;I37<>$B$25;J37<>$B$25);$B$25;"")))))))))
cordialement,