{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Feuil2","index":0,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"MENU"]
["Info8","info13",null,null,null,"<<cette cellule vide permet l'affichage de la liste au début quand on sélectionne H5:H10"]
["info 68","info18",null,null,{"$f":"IF(COUNTIF($E$2:E2,\"<>\")<COUNTA($A$2:$A$100),A2,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E2)*1))))","v":"Info8"},"le champ de E2:E40 est nommé MENU pour pouvoir être utilisée sur une autre feuille"]
["Info2","info20",null,null,{"$f":"IF(COUNTIF($E$2:E3,\"<>\")<COUNTA($A$2:$A$100),A3,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E3)*1))))","v":"info 68"},"on peut compliquer pour enlever les 0 à la fin de la liste"]
["Info5","info23",null,null,{"$f":"IF(COUNTIF($E$2:E4,\"<>\")<COUNTA($A$2:$A$100),A4,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E4)*1))))","v":"Info2"}]
["info 66","info19",null,null,{"$f":"IF(COUNTIF($E$2:E5,\"<>\")<COUNTA($A$2:$A$100),A5,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E5)*1))))","v":"Info5"}]
["Info6","info12",null,null,{"$f":"IF(COUNTIF($E$2:E6,\"<>\")<COUNTA($A$2:$A$100),A6,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E6)*1))))","v":"info 66"}]
["Info1","info10",null,null,{"$f":"IF(COUNTIF($E$2:E7,\"<>\")<COUNTA($A$2:$A$100),A7,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E7)*1))))","v":"Info6"}]
["info 65","info14",null,null,{"$f":"IF(COUNTIF($E$2:E8,\"<>\")<COUNTA($A$2:$A$100),A8,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E8)*1))))","v":"Info1"}]
["Info4","info16",null,null,{"$f":"IF(COUNTIF($E$2:E9,\"<>\")<COUNTA($A$2:$A$100),A9,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E9)*1))))","v":"info 65"}]
["info 70","info21",null,null,{"$f":"IF(COUNTIF($E$2:E10,\"<>\")<COUNTA($A$2:$A$100),A10,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E10)*1))))","v":"Info4"}]
["Info3","info11",null,null,{"$f":"IF(COUNTIF($E$2:E11,\"<>\")<COUNTA($A$2:$A$100),A11,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E11)*1))))","v":"info 70"}]
["info 69","info22",null,null,{"$f":"IF(COUNTIF($E$2:E12,\"<>\")<COUNTA($A$2:$A$100),A12,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E12)*1))))","v":"Info3"}]
[null,"info15",null,null,{"$f":"IF(COUNTIF($E$2:E13,\"<>\")<COUNTA($A$2:$A$100),A13,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E13)*1))))","v":"info 69"}]
[null,"info24",null,null,{"$f":"IF(COUNTIF($E$2:E14,\"<>\")<COUNTA($A$2:$A$100),A14,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E14)*1))))","v":"info13"}]
[null,"info17",null,null,{"$f":"IF(COUNTIF($E$2:E15,\"<>\")<COUNTA($A$2:$A$100),A15,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E15)*1))))","v":"info18"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E16,\"<>\")<COUNTA($A$2:$A$100),A16,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E16)*1))))","v":"info20"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E17,\"<>\")<COUNTA($A$2:$A$100),A17,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E17)*1))))","v":"info23"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E18,\"<>\")<COUNTA($A$2:$A$100),A18,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E18)*1))))","v":"info19"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E19,\"<>\")<COUNTA($A$2:$A$100),A19,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E19)*1))))","v":"info12"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E20,\"<>\")<COUNTA($A$2:$A$100),A20,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E20)*1))))","v":"info10"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E21,\"<>\")<COUNTA($A$2:$A$100),A21,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E21)*1))))","v":"info14"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E22,\"<>\")<COUNTA($A$2:$A$100),A22,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E22)*1))))","v":"info16"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E23,\"<>\")<COUNTA($A$2:$A$100),A23,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E23)*1))))","v":"info21"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E24,\"<>\")<COUNTA($A$2:$A$100),A24,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E24)*1))))","v":"info11"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E25,\"<>\")<COUNTA($A$2:$A$100),A25,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E25)*1))))","v":"info22"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E26,\"<>\")<COUNTA($A$2:$A$100),A26,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E26)*1))))","v":"info15"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E27,\"<>\")<COUNTA($A$2:$A$100),A27,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E27)*1))))","v":"info24"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E28,\"<>\")<COUNTA($A$2:$A$100),A28,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E28)*1))))","v":"info17"}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E29,\"<>\")<COUNTA($A$2:$A$100),A29,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E29)*1))))","v":0}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E30,\"<>\")<COUNTA($A$2:$A$100),A30,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E30)*1))))","v":0}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E31,\"<>\")<COUNTA($A$2:$A$100),A31,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E31)*1))))","v":0}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E32,\"<>\")<COUNTA($A$2:$A$100),A32,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E32)*1))))","v":0}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E33,\"<>\")<COUNTA($A$2:$A$100),A33,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E33)*1))))","v":0}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E34,\"<>\")<COUNTA($A$2:$A$100),A34,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E34)*1))))","v":0}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E35,\"<>\")<COUNTA($A$2:$A$100),A35,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E35)*1))))","v":0}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E36,\"<>\")<COUNTA($A$2:$A$100),A36,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E36)*1))))","v":0}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E37,\"<>\")<COUNTA($A$2:$A$100),A37,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E37)*1))))","v":0}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E38,\"<>\")<COUNTA($A$2:$A$100),A38,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E38)*1))))","v":0}]
[null,null,null,null,{"$f":"IF(COUNTIF($E$2:E39,\"<>\")<COUNTA($A$2:$A$100),A39,INDIRECT(\"B\"&ROW()-1-SUMPRODUCT((COUNTIF($A$2:$A$100,$E$2:E39)*1))))","v":0}]

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