La formule se situe dans les tableaux de gauche, colonne "Présent/Absent".
Sinon voici la formule ... :
=SI(OU($B$8=AC11;$B$9=AC11;$B$10=AC11;$B$11=AC11;$B$12=AC11;$B$13=AC11;$B$14=AC11;$B$15=AC11;
$B$16=AC11);$B$6;SI(OU($D$8=AC11;$D$9=AC11;$D$10=AC11;$D$11=AC11;$D$12=AC11;$D$13=AC11;$D$14=AC11;
$D$15=AC11;$D$16=AC11);$D$6;SI(OU($F$8=AC11;$F$9=AC11;$F$10=AC11;$F$11=AC11;$F$12=AC11;$F$13=AC11;
$F$14=AC11;$F$15=AC11;$F$16=AC11);$F$6;SI(OU($H$8=AC11;$H$9=AC11;$H$10=AC11;$H$11=AC11;$H$12=AC11;
$H$13=AC11;$H$14=AC11;$H$15=AC11;$H$16=AC11);$H$6;SI(OU($J$8=AC11;$J$9=AC11;$J$10=AC11;$J$11=AC11;
$J$12=AC11;$J$13=AC11;$J$14=AC11;$J$15=AC11;$J$16=AC11);$J$6;SI(OU($L$8=AC11;$L$9=AC11;$L$10=AC11;
$L$11=AC11;$L$12=AC11;$L$13=AC11;$L$14=AC11;$L$15=AC11;$L$16=AC11);$L$6;SI(OU($N$8=AC11;$N$9=AC11;
$N$10=AC11;$N$11=AC11;$N$12=AC11;$N$13=AC11;$N$14=AC11;$N$15=AC11;$N$16=AC11);$N$6;SI(OU($P$8=AC11;
$P$9=AC11;$P$10=AC11;$P$11=AC11;$P$12=AC11;$P$13=AC11;$P$14=AC11;$P$15=AC11;$P$16=AC11);$P$6;SI(OU($R$8=AC11;
$R$9=AC11;$R$10=AC11;$R$11=AC11;$R$12=AC11;$R$13=AC11;$R$14=AC11;$R$15=AC11;$R$16=AC11);$R$6;SI(OU($T$8=AC11;$T$9=AC11;$T$10=AC11;$T$11=AC11;$T$12=AC11;$T$13=AC11;$T$14=AC11;$T$15=AC11;$T$16=AC11);$T$6;SI(OU($V$8=AC11;
$V$9=AC11;$V$10=AC11;$V$11=AC11;$V$12=AC11;$V$13=AC11;$V$14=AC11;$V$15=AC11;$V$16=AC11);$V$6;
SI(OU($X$8=AC11;$X$9=AC11;$X$10=AC11;$X$11=AC11;$X$12=AC11;$X$13=AC11;$X$14=AC11;$X$15=AC11;$X$16=AC11);
$X$6;"NON AFFECTE"))))))))))))
Cordialement.