Re : age : mini et maxi
Bonjour Richardlafrite, Brigitte,
Voici 2 formules (à valider par <CTRL>+<MAJ>+<CTRL>) :
=INDEX($C$3:$C$111;EQUIV(MIN(SI($B$3:$B$111<>"x";D ATEDIF($B$3:$B$111;$A$3:$A$111;"m")));DATEDIF($B$3 :$B$111;$A$3:$A$111;"m");0);1)
=INDEX($C$3:$C$111;EQUIV(MAX(SI($B$3:$B$111<>"x";D ATEDIF($B$3:$B$111;$A$3:$A$111;"m")));DATEDIF($B$3 :$B$111;$A$3:$A$111;"m");0);1)
__________________
@+
cbea
|