{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,2,2,7],[1,2,1,10],[12,2,12,10],[13,2,13,7]]}
[]
[null,null,"SITUATION PRESENTE",null,null,null,null,null,null,null,null,null,"NOMBRE INF. A :"]
[null,null,"SERIES",null,null,null,null,null,null,"NOMBRE \"PAIR\"","NOMBRE \"IMPAIR\"",null,2,"SERIES A ELIMINER"]
[null,{"$f":"B3+M4","v":1},1,2,3,4,5,6,null,{"$f":"FindPair(C4,D4,E4,F4,G4,H4)","v":3},{"$f":"FindImpair(C4,D4,E4,F4,G4,H4)","v":3},null,{"$f":"IF(OR(J4<$M$3,K4<$M$3),0,1)","v":1}]
[null,{"$f":"B4+M5","v":2},2,5,6,7,9,15,null,{"$f":"FindPair(C5,D5,E5,F5,G5,H5)","v":2},{"$f":"FindImpair(C5,D5,E5,F5,G5,H5)","v":4},null,{"$f":"IF(OR(J5<$M$3,K5<$M$3),0,1)","v":1}]
[null,2,7,11,13,14,17,19,null,{"$f":"FindPair(C6,D6,E6,F6,G6,H6)","v":1},{"$f":"FindImpair(C6,D6,E6,F6,G6,H6)","v":5},null,0,"A EFFACER DE LA LISTE"]
[null,3,10,12,16,20,21,23,null,{"$f":"FindPair(C7,D7,E7,F7,G7,H7)","v":4},{"$f":"FindImpair(C7,D7,E7,F7,G7,H7)","v":2},null,1]
[null,3,2,3,4,6,8,10,null,{"$f":"FindPair(C8,D8,E8,F8,G8,H8)","v":5},{"$f":"FindImpair(C8,D8,E8,F8,G8,H8)","v":1},null,0,"A EFFACER DE LA LISTE"]
[null,3,3,5,7,9,11,13,null,{"$f":"FindPair(C9,D9,E9,F9,G9,H9)","v":0},{"$f":"FindImpair(C9,D9,E9,F9,G9,H9)","v":6},null,0,"A EFFACER DE LA LISTE"]
[]
[]
[]
[null,null,"CE QUE JE VEUX"]
[null,null,"SERIES",null,null,null,null,null,null,"NOMBRE \"PAIR\"","NOMBRE \"IMPAIR\"",null,"NOMBRE INF. A 2"]
[null,null,{"$f":"IFERROR(VLOOKUP(ROW()-14,$B$4:$M$9,COLUMN()-1,FALSE),\"\")","v":1},{"$f":"IFERROR(VLOOKUP(ROW()-14,$B$4:$M$9,COLUMN()-1,FALSE),\"\")","v":2},{"$f":"IFERROR(VLOOKUP(ROW()-14,$B$4:$M$9,COLUMN()-1,FALSE),\"\")","v":3},{"$f":"IFERROR(VLOOKUP(ROW()-14,$B$4:$M$9,COLUMN()-1,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP(ROW()-14,$B$4:$M$9,COLUMN()-1,FALSE),\"\")","v":5},{"$f":"IFERROR(VLOOKUP(ROW()-14,$B$4:$M$9,COLUMN()-1,FALSE),\"\")","v":6},null,{"$f":"IFERROR(VLOOKUP(ROW()-14,$B$4:$M$9,COLUMN()-1,FALSE),\"\")","v":3},{"$f":"IFERROR(VLOOKUP(ROW()-14,$B$4:$M$9,COLUMN()-1,FALSE),\"\")","v":3},null,{"$f":"COUNTIF(C15:C20,\">0\")","v":3}]
[null,null,{"$f":"IFERROR(VLOOKUP(ROW()-14,$B$4:$M$9,COLUMN()-1,FALSE),\"\")","v":2},5,6,7,9,15,null,2,4]
[null,null,10,12,16,20,21,23,null,4,2]
[null,null,"","","","","","",null,"",""]
[null,null,"","","","","","",null,"",""]
[null,null,"","","","","","",null,"",""]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,1,"La détermination des colonnes J4  à K9 se fait grâce à deux fonctions personnalisées qui se trouve dans le VBA / module 1 : FindPair(S1, S2, S3, S4, S5, S6)  et FindImpair(S1, S2, S3, S4, S5, S6)"]
[null,null,null,null,null,null,null,null,null,null,null,2,"En M3 on encode la limite désirée : ici 2"]
[null,null,null,null,null,null,null,null,null,null,null,3,"La plage M4:M9 se détermine grâce à la formule : SI(OU(J4<$M$3;K4<$M$3);0;1)"]
[null,null,null,null,null,null,null,null,null,null,null,4,"La colonne B numérote les lignes qui doivent être reprise dans le tableau de synthèse.   Cette colonne est technique et peut être masquée"]
[null,null,null,null,null,null,null,null,null,null,null,5,"Le tableau de synthèse se constirue grâce à la formule : SIERREUR(RECHERCHEV(LIGNE()-14;$B$4:$M$9;COLONNE()-1;FAUX);\"\")"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cette recherche va sélectionner en fonction de la numérotation des lignes à reprendre"]