Problème de compatabilité de formules entre Excel 2013 et Excel 365
Bonjour,
Je suis bloqué sur des formules qui a été crée sur Excel 2013 et lorsque que j'ouvre Excel 365 (aucune erreur n'apparait) aucun n'est effectué.
Pouvez-vous m'aider sur ces 3 formules me dire la différence ? ou m'expliquer pourquoi mes formules ne marchent pas sur 365 ? s'il vous plaît
Formule 1 :
=IFERROR(@INDEX('Samples info'!$B$3:$B$202;AGGREGATE(15;6;(LEFT('Samples info'!$B$3:$B$202;LEN(A3))=TEXT(A3;"General"))/(LEFT('Samples info'!$B$3:$B$202;LEN(A3))=TEXT(A3;"General"))*ROW('Samples info'!$B$3:$B$202)-ROWS('Samples info'!$B$1:$B$2);ROW()-ROW(A3)));"")
Formule 2 :
=IFERROR(@INDEX('Results summary'!$N$30:$N$229;AGGREGATE(15;6;(LEFT('Results summary'!$D$30:$D$229;LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;2;FALSE)))=TEXT(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;2;FALSE);"General"))/(LEFT('Results summary'!$D$30:$D$229;LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;2;FALSE)))=TEXT(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;2;FALSE);"General"))*ROW('Results summary'!$C$30:$C$229)-ROWS('Results summary'!$C$1:$C$29);ROW()-MATCH(A3;$A:$A;0)));"")
Formule 3:
=IFERROR(@IF(IFERROR(AND(LEFT(@INDEX('Results summary'!$O$30:$BC$229;AGGREGATE(15;6;(LEFT('Results summary'!$D$30:$D$229;LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;2;FALSE)))=TEXT(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;2;FALSE);"General"))/(LEFT('Results summary'!$D$30:$D$229;LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;2;FALSE)))=TEXT(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;2;FALSE);"General"))*ROW('Results summary'!$C$30:$C$229)-ROWS('Results summary'!$C$1:$C$29);ROW()-MATCH(A3;$A:$A;0));AGGREGATE(15;6;('STD info'!$C$7:$AQ$7=1)/('STD info'!$C$7:$AQ$7=1)*COLUMN('STD info'!$C$7:$AQ$7)-COLUMNS('STD info'!$A$7:$B$7);COLUMNS('Rep Indiv'!$C7:C7)));1)=">";@INDEX('Results summary'!$O$30:$BC$229;AGGREGATE(15;6;(LEFT('Results summary'!$D$30:$D$229;IF(LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;3;FALSE))=0;NA;LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;3;FALSE))))=TEXT(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;3;FALSE);"General"))/(LEFT('Results summary'!$D$30:$D$229;IF(LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;3;FALSE))=0;NA;LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;3;FALSE))))=TEXT(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;3;FALSE);"General"))*ROW('Results summary'!$C$30:$C$229)-ROWS('Results summary'!$C$1:$C$29);ROW()-MATCH(A3;$A:$A;0));AGGREGATE(15;6;('STD info'!$C$7:$AQ$7=1)/('STD info'!$C$7:$AQ$7=1)*COLUMN('STD info'!$C$7:$AQ$7)-COLUMNS('STD info'!$A$7:$B$7);COLUMNS('Rep Indiv'!$C7:C7)))<>"");FALSE);INDEX('Results summary'!$O$30:$BC$229;AGGREGATE(15;6;(LEFT('Results summary'!$D$30:$D$229;IF(LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;3;FALSE))=0;NA;LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;3;FALSE))))=TEXT(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;3;FALSE);"General"))/(LEFT('Results summary'!$D$30:$D$229;IF(LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;3;FALSE))=0;NA;LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;3;FALSE))))=TEXT(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;3;FALSE);"General"))*ROW('Results summary'!$C$30:$C$229)-ROWS('Results summary'!$C$1:$C$29);ROW()-MATCH(A3;$A:$A;0));AGGREGATE(15;6;('STD info'!$C$7:$AQ$7=1)/('STD info'!$C$7:$AQ$7=1)*COLUMN('STD info'!$C$7:$AQ$7)-COLUMNS('STD info'!$A$7:$B$7);COLUMNS('Rep Indiv'!$C7:C7)));INDEX('Results summary'!$O$30:$BC$229;AGGREGATE(15;6;(LEFT('Results summary'!$D$30:$D$229;LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;2;FALSE)))=TEXT(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;2;FALSE);"General"))/(LEFT('Results summary'!$D$30:$D$229;LEN(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;2;FALSE)))=TEXT(VLOOKUP(A3;'Nom du document'!$C$17:$G$31;2;FALSE);"General"))*ROW('Results summary'!$C$30:$C$229)-ROWS('Results summary'!$C$1:$C$29);ROW()-MATCH(A3;$A:$A;0));AGGREGATE(15;6;('STD info'!$C$7:$AQ$7=1)/('STD info'!$C$7:$AQ$7=1)*COLUMN('STD info'!$C$7:$AQ$7)-COLUMNS('STD info'!$A$7:$B$7);COLUMNS('Rep Indiv'!$C7:C7))));"")
Merci d'avance
Cordialement
C.