{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,1,7,1],[23,4,23,5]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,"1er match","2ème match","3ème match","TOTAL","Pour","Contre","GO"]
[null,"C","France",3,2,"Australie",{"$f":"IF(D5>E5,C5,IF(D5<E5,F5,\"X\"))","v":"France"},"Danemark",{"$f":"IF($D$6=\"\",\"\",IF($D$6<$E$6,3,IF($D$6>$E$6,0,1)))","v":3},{"$f":"IF($D$7=\"\",\"\",IF($D$7<$E$7,0,IF($D$7>$E$7,3,1)))","v":0},{"$f":"IF($D$9=\"\",\"\",IF($D$9>$E$9,0,IF($D$9<$E$9,3,1)))","v":3},{"$f":"SUM(I5:K5)","v":6},{"$f":"E6+D7+D9","v":7},{"$f":"D6+E7+E9","v":3},{"$f":"M5-N5","v":4}]
[null,null,"Pérou",0,7,"Danemark",{"$f":"IF(D6>E6,C6,IF(D6<E6,F6,\"X\"))","v":"Danemark"},"France",{"$f":"IF($D$5=\"\",\"\",IF($D$5>$E$5,3,IF($D$5<$E$5,0,1)))","v":3},{"$f":"IF($D$8=\"\",\"\",IF($D$8<$E$8,0,IF($D$8>$E$8,3,1)))","v":3},{"$f":"IF($D$9=\"\",\"\",IF($D$9<$E$9,0,IF($D$9>$E$9,3,1)))","v":0},{"$f":"SUM(I6:K6)","v":6},{"$f":"D5+D8+E9","v":7},{"$f":"E5+E8+D9","v":3},{"$f":"M6-N6","v":4}]
[null,null,"Danemark",0,1,"Australie","Australie","Australie",{"$f":"IF($D$5=\"\",\"\",IF($D$5<$E$5,3,IF($D$5>$E$5,0,1)))","v":0},{"$f":"IF($D$7=\"\",\"\",IF($D$7>$E$7,0,IF($D$7<$E$7,3,1)))","v":3},{"$f":"IF($D$10=\"\",\"\",IF($D$10<$E$10,0,IF($D$10>$E$10,3,1)))","v":1},{"$f":"SUM(I7:K7)","v":4},{"$f":"E4+E6+D9","v":7},{"$f":"D4+D6+E9","v":2},{"$f":"M7-N7","v":5}]
[null,null,"France",2,1,"Pérou","France","Pérou",{"$f":"IF($D$6=\"\",\"\",IF($D$6>$E$6,3,IF($D$6<$E$6,0,1)))","v":0},{"$f":"IF($D$8=\"\",\"\",IF($D$8>$E$8,0,IF($D$8<$E$8,3,1)))","v":0},{"$f":"IF($D$10=\"\",\"\",IF($D$10>$E$10,0,IF($D$10<$E$10,3,1)))","v":1},{"$f":"SUM(I8:K8)","v":1},{"$f":"D7+E9+E11","v":2},{"$f":"E7+D9+D11","v":1},{"$f":"M8-N8","v":1}]
[null,null,"Danemark",0,2,"France","France"]
[null,null,"Australie",0,0,"Pérou","X",null," "]
[]
[null,null,"Bouton Tri C : permet de trier les colonnes H5 à O8 selon l'ordre suivant :",null,null,null,null,null,"1 - colonne Total"]
[null,null,null,null,null,null,null,null,"2 - colonne GO"]
[null,null,null,null,null,null,null,null,"3 - colonne Pour"]
[null,null,null,null,null,null,null,null,"4 - colonne Contre"]
[]
[null,null,"Mon problème :",null,"dans cet exemple France et Danemark ont une totale égalité : 6 au total, 4 au GO, 7 en Pour et 3 en Contre"]
[null,null,null,null,"ce qui va déterminer qui est premier et qui est second est le match entre ces deux pays, à savoir la France en tête"]
[null,null,null,null,"puisque vainqueur du match (lignes D9-E9)."]
[]
[null,null,null,null,"Quelle formule (ou maco) créer pour qu'Excel exécute ce tri correctement (sachant que les 4 pays peuvent être impactés"]
[null,null,null,null,"les uns avec les autres) ?"]
[]
[null,null,null,null,"Merci d'avance"]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}