{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","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":"Feuil1","index":0,"n_rows":105,"n_cols":5,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
["Liste initiale","codage","Liste du menu",null,"menu déroulant associé (entrer une plusieurs lettres du début du texte cherché)"]
["Paul",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A2,LEN($E$2))=$E$2,MAX($B$1:B1)+1,\"\"))","v":1},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(A1),B:B,0)),\"\")","v":"Paul"},null,"P"]
["Renè",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A3,LEN($E$2))=$E$2,MAX($B$1:B2)+1,\"\"))","v":""},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(A2),B:B,0)),\"\")","v":"Patrick"}]
["André",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A4,LEN($E$2))=$E$2,MAX($B$1:B3)+1,\"\"))","v":""},"Paul"]
["Ewan",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A5,LEN($E$2))=$E$2,MAX($B$1:B4)+1,\"\"))","v":""},"Patrick"]
["Marcel",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A6,LEN($E$2))=$E$2,MAX($B$1:B5)+1,\"\"))","v":""},"Paul"]
["Patrick",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A7,LEN($E$2))=$E$2,MAX($B$1:B6)+1,\"\"))","v":2},"Pin",null,"La liste du menun est nommée Liste"]
["Eric",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A8,LEN($E$2))=$E$2,MAX($B$1:B7)+1,\"\"))","v":""},"Pommiers",null,"elle s'ajuste sur les texte qui débutent par celui inscrit en E2 quelque soit leur longueur"]
["Corinne",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A9,LEN($E$2))=$E$2,MAX($B$1:B8)+1,\"\"))","v":""},"Pruniers",null,"cette liste est nommée via la formule:=DECALER(Feuil1!$C$2;;NB.SI($C$2:$C$40;\"><\"))"]
["Chrystel",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A10,LEN($E$2))=$E$2,MAX($B$1:B9)+1,\"\"))","v":""},"Peuplier",null,"Nota: la liste une fois nommée peut être utilisée sur une autre feuille"]
["Monique",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A11,LEN($E$2))=$E$2,MAX($B$1:B10)+1,\"\"))","v":""},"Palmier"]
["Léa",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A12,LEN($E$2))=$E$2,MAX($B$1:B11)+1,\"\"))","v":""},"Poirier",null,"pour placer la validation afin de pouvoir écrire le début de texte:"]
["Lucas",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A13,LEN($E$2))=$E$2,MAX($B$1:B12)+1,\"\"))","v":""},"ParIs",null,"dans la fenêtre de validation"]
["Paul",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A14,LEN($E$2))=$E$2,MAX($B$1:B13)+1,\"\"))","v":3},"Perpignan",null,"=Nom de la liste"]
["Renè",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A15,LEN($E$2))=$E$2,MAX($B$1:B14)+1,\"\"))","v":""},"Pau",null,"cliquer sur l'onglet \"alerte d'erreur\" et décochez > \"quand les données non valides sont tapées\""]
["André",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A16,LEN($E$2))=$E$2,MAX($B$1:B15)+1,\"\"))","v":""},"Platère"]
["Ewan",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A17,LEN($E$2))=$E$2,MAX($B$1:B16)+1,\"\"))","v":""},"Paquite"]
["Marcel",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A18,LEN($E$2))=$E$2,MAX($B$1:B17)+1,\"\"))","v":""},""]
["Patrick",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A19,LEN($E$2))=$E$2,MAX($B$1:B18)+1,\"\"))","v":4},""]
["Eric",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A20,LEN($E$2))=$E$2,MAX($B$1:B19)+1,\"\"))","v":""},""]
["Corinne",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A21,LEN($E$2))=$E$2,MAX($B$1:B20)+1,\"\"))","v":""},""]
["Chrystel",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A22,LEN($E$2))=$E$2,MAX($B$1:B21)+1,\"\"))","v":""},""]
["Monique",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A23,LEN($E$2))=$E$2,MAX($B$1:B22)+1,\"\"))","v":""},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(A22),B:B,0)),\"\")","v":""}]
["Léa",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A24,LEN($E$2))=$E$2,MAX($B$1:B23)+1,\"\"))","v":""},""]
["Lucas",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A25,LEN($E$2))=$E$2,MAX($B$1:B24)+1,\"\"))","v":""},""]
["Paul",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A26,LEN($E$2))=$E$2,MAX($B$1:B25)+1,\"\"))","v":5},""]
["Renè",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A27,LEN($E$2))=$E$2,MAX($B$1:B26)+1,\"\"))","v":""},""]
["Chêne",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A28,LEN($E$2))=$E$2,MAX($B$1:B27)+1,\"\"))","v":""},""]
["Bouleau",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A29,LEN($E$2))=$E$2,MAX($B$1:B28)+1,\"\"))","v":""},""]
["Sapin",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A30,LEN($E$2))=$E$2,MAX($B$1:B29)+1,\"\"))","v":""},""]
["Epicea",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A31,LEN($E$2))=$E$2,MAX($B$1:B30)+1,\"\"))","v":""},""]
["Méléze",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A32,LEN($E$2))=$E$2,MAX($B$1:B31)+1,\"\"))","v":""},""]
["Pin",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A33,LEN($E$2))=$E$2,MAX($B$1:B32)+1,\"\"))","v":6},""]
["Orme",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A34,LEN($E$2))=$E$2,MAX($B$1:B33)+1,\"\"))","v":""},""]
["Orne",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A35,LEN($E$2))=$E$2,MAX($B$1:B34)+1,\"\"))","v":""},""]
["Acacuia",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A36,LEN($E$2))=$E$2,MAX($B$1:B35)+1,\"\"))","v":""},""]
["Pommiers",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A37,LEN($E$2))=$E$2,MAX($B$1:B36)+1,\"\"))","v":7},""]
["Pruniers",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A38,LEN($E$2))=$E$2,MAX($B$1:B37)+1,\"\"))","v":8},""]
["Frêne",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A39,LEN($E$2))=$E$2,MAX($B$1:B38)+1,\"\"))","v":""},""]
["Peuplier",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A40,LEN($E$2))=$E$2,MAX($B$1:B39)+1,\"\"))","v":9},""]
["Châtaignier",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A41,LEN($E$2))=$E$2,MAX($B$1:B40)+1,\"\"))","v":""}]
["Olivier",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A42,LEN($E$2))=$E$2,MAX($B$1:B41)+1,\"\"))","v":""}]
["Erable",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A43,LEN($E$2))=$E$2,MAX($B$1:B42)+1,\"\"))","v":""}]
["Séquoia",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A44,LEN($E$2))=$E$2,MAX($B$1:B43)+1,\"\"))","v":""}]
["Palmier",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A45,LEN($E$2))=$E$2,MAX($B$1:B44)+1,\"\"))","v":10}]
["Cocotier",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A46,LEN($E$2))=$E$2,MAX($B$1:B45)+1,\"\"))","v":""}]
["Buis",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A47,LEN($E$2))=$E$2,MAX($B$1:B46)+1,\"\"))","v":""}]
["Houx",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A48,LEN($E$2))=$E$2,MAX($B$1:B47)+1,\"\"))","v":""}]
["Mimosa",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A49,LEN($E$2))=$E$2,MAX($B$1:B48)+1,\"\"))","v":""}]
["Poirier",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A50,LEN($E$2))=$E$2,MAX($B$1:B49)+1,\"\"))","v":11}]
["Abricotier",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A51,LEN($E$2))=$E$2,MAX($B$1:B50)+1,\"\"))","v":""}]
["Charme",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A52,LEN($E$2))=$E$2,MAX($B$1:B51)+1,\"\"))","v":""}]
["Saule",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A53,LEN($E$2))=$E$2,MAX($B$1:B52)+1,\"\"))","v":""}]
["ParIs",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A54,LEN($E$2))=$E$2,MAX($B$1:B53)+1,\"\"))","v":12}]
["Marseille",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A55,LEN($E$2))=$E$2,MAX($B$1:B54)+1,\"\"))","v":""}]
["Lyon",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A56,LEN($E$2))=$E$2,MAX($B$1:B55)+1,\"\"))","v":""}]
["Birdeaux",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A57,LEN($E$2))=$E$2,MAX($B$1:B56)+1,\"\"))","v":""}]
["Brunois",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A58,LEN($E$2))=$E$2,MAX($B$1:B57)+1,\"\"))","v":""}]
["Toul",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A59,LEN($E$2))=$E$2,MAX($B$1:B58)+1,\"\"))","v":""}]
["Vezoul",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A60,LEN($E$2))=$E$2,MAX($B$1:B59)+1,\"\"))","v":""}]
["Vierzon",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A61,LEN($E$2))=$E$2,MAX($B$1:B60)+1,\"\"))","v":""}]
["Limoges",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A62,LEN($E$2))=$E$2,MAX($B$1:B61)+1,\"\"))","v":""}]
["Brest",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A63,LEN($E$2))=$E$2,MAX($B$1:B62)+1,\"\"))","v":""}]
["Nantes",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A64,LEN($E$2))=$E$2,MAX($B$1:B63)+1,\"\"))","v":""}]
["Montpellier",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A65,LEN($E$2))=$E$2,MAX($B$1:B64)+1,\"\"))","v":""}]
["Toulouse",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A66,LEN($E$2))=$E$2,MAX($B$1:B65)+1,\"\"))","v":""}]
["Perpignan",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A67,LEN($E$2))=$E$2,MAX($B$1:B66)+1,\"\"))","v":13}]
["Pau",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A68,LEN($E$2))=$E$2,MAX($B$1:B67)+1,\"\"))","v":14}]
["Bourg-en -Bresse",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A69,LEN($E$2))=$E$2,MAX($B$1:B68)+1,\"\"))","v":""}]
["Gex",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A70,LEN($E$2))=$E$2,MAX($B$1:B69)+1,\"\"))","v":""}]
["Bellegarde",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A71,LEN($E$2))=$E$2,MAX($B$1:B70)+1,\"\"))","v":""}]
["Strasbourg",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A72,LEN($E$2))=$E$2,MAX($B$1:B71)+1,\"\"))","v":""}]
["Colmar",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A73,LEN($E$2))=$E$2,MAX($B$1:B72)+1,\"\"))","v":""}]
["Mulhouse",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A74,LEN($E$2))=$E$2,MAX($B$1:B73)+1,\"\"))","v":""}]
["Belfort",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A75,LEN($E$2))=$E$2,MAX($B$1:B74)+1,\"\"))","v":""}]
["Nacy",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A76,LEN($E$2))=$E$2,MAX($B$1:B75)+1,\"\"))","v":""}]
["Dijon",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A77,LEN($E$2))=$E$2,MAX($B$1:B76)+1,\"\"))","v":""}]
["Metz",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A78,LEN($E$2))=$E$2,MAX($B$1:B77)+1,\"\"))","v":""}]
["Calais",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A79,LEN($E$2))=$E$2,MAX($B$1:B78)+1,\"\"))","v":""}]
["Martin",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A80,LEN($E$2))=$E$2,MAX($B$1:B79)+1,\"\"))","v":""}]
["Durand",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A81,LEN($E$2))=$E$2,MAX($B$1:B80)+1,\"\"))","v":""}]
["Xitana",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A82,LEN($E$2))=$E$2,MAX($B$1:B81)+1,\"\"))","v":""}]
["Abrani",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A83,LEN($E$2))=$E$2,MAX($B$1:B82)+1,\"\"))","v":""}]
["Marcello",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A84,LEN($E$2))=$E$2,MAX($B$1:B83)+1,\"\"))","v":""}]
["Teilhol",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A85,LEN($E$2))=$E$2,MAX($B$1:B84)+1,\"\"))","v":""}]
["Platère",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A86,LEN($E$2))=$E$2,MAX($B$1:B85)+1,\"\"))","v":15}]
["Morel",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A87,LEN($E$2))=$E$2,MAX($B$1:B86)+1,\"\"))","v":""}]
["Paquite",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A88,LEN($E$2))=$E$2,MAX($B$1:B87)+1,\"\"))","v":16}]
["Kourta",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A89,LEN($E$2))=$E$2,MAX($B$1:B88)+1,\"\"))","v":""}]
["Banaci",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A90,LEN($E$2))=$E$2,MAX($B$1:B89)+1,\"\"))","v":""}]
["Blanquet",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A91,LEN($E$2))=$E$2,MAX($B$1:B90)+1,\"\"))","v":""}]
["Romara",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A92,LEN($E$2))=$E$2,MAX($B$1:B91)+1,\"\"))","v":""}]
["Uberto",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A93,LEN($E$2))=$E$2,MAX($B$1:B92)+1,\"\"))","v":""}]
["Humbert",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A94,LEN($E$2))=$E$2,MAX($B$1:B93)+1,\"\"))","v":""}]
["Carline",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A95,LEN($E$2))=$E$2,MAX($B$1:B94)+1,\"\"))","v":""}]
["Esmerh",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A96,LEN($E$2))=$E$2,MAX($B$1:B95)+1,\"\"))","v":""}]
["Fontanelle",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A97,LEN($E$2))=$E$2,MAX($B$1:B96)+1,\"\"))","v":""}]
["Galibot",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A98,LEN($E$2))=$E$2,MAX($B$1:B97)+1,\"\"))","v":""}]
["Hizarde",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A99,LEN($E$2))=$E$2,MAX($B$1:B98)+1,\"\"))","v":""}]
["Journey",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A100,LEN($E$2))=$E$2,MAX($B$1:B99)+1,\"\"))","v":""}]
["Latour",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A101,LEN($E$2))=$E$2,MAX($B$1:B100)+1,\"\"))","v":""}]
["Matone",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A102,LEN($E$2))=$E$2,MAX($B$1:B101)+1,\"\"))","v":""}]
["Nouche",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A103,LEN($E$2))=$E$2,MAX($B$1:B102)+1,\"\"))","v":""}]
["Oralando",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A104,LEN($E$2))=$E$2,MAX($B$1:B103)+1,\"\"))","v":""}]
["Questimbert",{"$f":"IF($E$2=\"\",\"\",IF(LEFT($A105,LEN($E$2))=$E$2,MAX($B$1:B104)+1,\"\"))","v":""}]

{"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":[]}