{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Date de naissance","Codage","Liste nom sans doublon","Info","EDITION"]
["Arunia","Jean","1955-06-04",{"$f":"IF(COUNTIF($A$2:A2,A2)=1,MAX($D$1:D1)+1,\"\")","v":1},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Arunia"},"La liste des noms est nommée NOM","Nom","Prénom","Date"]
["Blanco","Roger","1955-06-04",{"$f":"IF(COUNTIF($A$2:A3,A3)=1,MAX($D$1:D2)+1,0)","v":2},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Blanco"},"formule de définition de NOM","Martin","Roger",{"$f":"IF(OR(G3=\"\",H3=\"\"),\"\",INDEX(C:C,MATCH(G3&H3,A:A&B:B,0)))","v":"2000-03-02"}]
["Blanco","Monique","2000-03-02",{"$f":"IF(COUNTIF($A$2:A4,A4)=1,MAX($D$1:D3)+1,0)","v":0},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Boitet"},"=DECALER(Feuil1!$G$1;1;;NB.SI(Feuil1!$F$2:$F$1000;\"><\"))","Nassin","Claude",{"$f":"IF(OR(G4=\"\",H4=\"\"),\"\",INDEX(C:C,MATCH(G4&H4,A:A&B:B,0)))","v":"2000-03-02"}]
["Boitet","Marcel","2000-03-02",{"$f":"IF(COUNTIF($A$2:A5,A5)=1,MAX($D$1:D4)+1,0)","v":3},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Born"},null,null,null,{"$f":"IF(OR(G5=\"\",H5=\"\"),\"\",INDEX(C:C,MATCH(G5&H5,A:A&B:B,0)))","v":""}]
["Born","Gilles","1955-06-04",{"$f":"IF(COUNTIF($A$2:A6,A6)=1,MAX($D$1:D5)+1,0)","v":4},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Corbin"},"La liste des prénoms est nommée Prénom",null,null,{"$f":"IF(OR(G6=\"\",H6=\"\"),\"\",INDEX(C:C,MATCH(G6&H6,A:A&B:B,0)))","v":""}]
["Corbin","Simone","1955-06-04",{"$f":"IF(COUNTIF($A$2:A7,A7)=1,MAX($D$1:D6)+1,0)","v":5},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Dupont"},"formule de définition de PRENOM",null,null,{"$f":"IF(OR(G7=\"\",H7=\"\"),\"\",INDEX(C:C,MATCH(G7&H7,A:A&B:B,0)))","v":""}]
["Dupont","Eugénie","2000-03-02",{"$f":"IF(COUNTIF($A$2:A8,A8)=1,MAX($D$1:D7)+1,0)","v":6},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Durand"},"=DECALER(Feuil1!$A$1;EQUIV($G3;Feuil1!$A$1:$A$10000;0)-1;;NB.SI(Feuil1!$A:$A;$G3))",null,null,{"$f":"IF(OR(G8=\"\",H8=\"\"),\"\",INDEX(C:C,MATCH(G8&H8,A:A&B:B,0)))","v":""}]
["Durand","Jacqueline","1955-06-04",{"$f":"IF(COUNTIF($A$2:A9,A9)=1,MAX($D$1:D8)+1,0)","v":7},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Exator"},null,null,null,{"$f":"IF(OR(G9=\"\",H9=\"\"),\"\",INDEX(C:C,MATCH(G9&H9,A:A&B:B,0)))","v":""}]
["Exator","Chantal","2000-03-02",{"$f":"IF(COUNTIF($A$2:A10,A10)=1,MAX($D$1:D9)+1,0)","v":8},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Fabri"},"Attention. Pour affecter créer le nom de cette liste (PRENOM), il faut être placé ",null,null,{"$f":"IF(OR(G10=\"\",H10=\"\"),\"\",INDEX(C:C,MATCH(G10&H10,A:A&B:B,0)))","v":""}]
["Fabri","Marcel","1955-06-04",{"$f":"IF(COUNTIF($A$2:A11,A11)=1,MAX($D$1:D10)+1,0)","v":9},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Haumal"},"dans la 1° cellule de la liste qui ereçoit le men u dréoulant (ici G3)",null,null,{"$f":"IF(OR(G11=\"\",H11=\"\"),\"\",INDEX(C:C,MATCH(G11&H11,A:A&B:B,0)))","v":""}]
["Fabri","Pierre","2000-03-02",{"$f":"IF(COUNTIF($A$2:A12,A12)=1,MAX($D$1:D11)+1,0)","v":0},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Isidon"},null,null,null,{"$f":"IF(OR(G12=\"\",H12=\"\"),\"\",INDEX(C:C,MATCH(G12&H12,A:A&B:B,0)))","v":""}]
["Haumal","Lucas","2000-03-02",{"$f":"IF(COUNTIF($A$2:A13,A13)=1,MAX($D$1:D12)+1,0)","v":10},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"jaboulet"},"La liste en A doit être classée par ordre alphabétique",null,null,{"$f":"IF(OR(G13=\"\",H13=\"\"),\"\",INDEX(C:C,MATCH(G13&H13,A:A&B:B,0)))","v":""}]
["Isidon","Eric","1955-06-04",{"$f":"IF(COUNTIF($A$2:A14,A14)=1,MAX($D$1:D13)+1,0)","v":11},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Karovitch"},null,null,null,{"$f":"IF(OR(G14=\"\",H14=\"\"),\"\",INDEX(C:C,MATCH(G14&H14,A:A&B:B,0)))","v":""}]
["Isidon","Frédéric","1910-09-05",{"$f":"IF(COUNTIF($A$2:A15,A15)=1,MAX($D$1:D14)+1,0)","v":0},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Lugani"},"La liste en E évolue si on compléte la liste en A et B",null,null,{"$f":"IF(OR(G15=\"\",H15=\"\"),\"\",INDEX(C:C,MATCH(G15&H15,A:A&B:B,0)))","v":""}]
["jaboulet","Josette","1955-06-04",{"$f":"IF(COUNTIF($A$2:A16,A16)=1,MAX($D$1:D15)+1,0)","v":12},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Marcove"},null,null,null,{"$f":"IF(OR(G16=\"\",H16=\"\"),\"\",INDEX(C:C,MATCH(G16&H16,A:A&B:B,0)))","v":""}]
["Karovitch","André","2000-03-02",{"$f":"IF(COUNTIF($A$2:A17,A17)=1,MAX($D$1:D16)+1,0)","v":13},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Martin"},"La colone G affiche le menu la liste de E",null,null,{"$f":"IF(OR(G17=\"\",H17=\"\"),\"\",INDEX(C:C,MATCH(G17&H17,A:A&B:B,0)))","v":""}]
["Lugani","Annette","2000-03-02",{"$f":"IF(COUNTIF($A$2:A18,A18)=1,MAX($D$1:D17)+1,0)","v":14},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Marvel"},null,null,null,{"$f":"IF(OR(G18=\"\",H18=\"\"),\"\",INDEX(C:C,MATCH(G18&H18,A:A&B:B,0)))","v":""}]
["Marcove","Kevin","2000-03-02",{"$f":"IF(COUNTIF($A$2:A19,A19)=1,MAX($D$1:D18)+1,0)","v":15},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Nassin"},"La colonne H affiche les prénoms correspondants au nom",null,null,{"$f":"IF(OR(G19=\"\",H19=\"\"),\"\",INDEX(C:C,MATCH(G19&H19,A:A&B:B,0)))","v":""}]
["Martin","Roger","2000-03-02",{"$f":"IF(COUNTIF($A$2:A20,A20)=1,MAX($D$1:D19)+1,0)","v":16},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Obosque"},null,null,null,{"$f":"IF(OR(G20=\"\",H20=\"\"),\"\",INDEX(C:C,MATCH(G20&H20,A:A&B:B,0)))","v":""}]
["Martin","Corinne","2000-03-02",{"$f":"IF(COUNTIF($A$2:A21,A21)=1,MAX($D$1:D20)+1,0)","v":0},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Partena"},"La formule en I est matricielle est doit être entrée:",null,null,{"$f":"IF(OR(G21=\"\",H21=\"\"),\"\",INDEX(C:C,MATCH(G21&H21,A:A&B:B,0)))","v":""}]
["Martin","Michel","2000-03-02",{"$f":"IF(COUNTIF($A$2:A22,A22)=1,MAX($D$1:D21)+1,0)","v":0},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Querty"},"avec la touche ENTER en maintenant trl et Shift enfoncée",null,null,{"$f":"IF(OR(G22=\"\",H22=\"\"),\"\",INDEX(C:C,MATCH(G22&H22,A:A&B:B,0)))","v":""}]
["Marvel","Chrystel","1955-06-04",{"$f":"IF(COUNTIF($A$2:A23,A23)=1,MAX($D$1:D22)+1,0)","v":17},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"Robino"},null,null,null,{"$f":"IF(OR(G23=\"\",H23=\"\"),\"\",INDEX(C:C,MATCH(G23&H23,A:A&B:B,0)))","v":""}]
["Nassin","Claude","2000-03-02",{"$f":"IF(COUNTIF($A$2:A24,A24)=1,MAX($D$1:D23)+1,0)","v":18},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":""},null,null,null,{"$f":"IF(OR(G24=\"\",H24=\"\"),\"\",INDEX(C:C,MATCH(G24&H24,A:A&B:B,0)))","v":""}]
["Obosque","Jacques","1955-06-04",{"$f":"IF(COUNTIF($A$2:A25,A25)=1,MAX($D$1:D24)+1,0)","v":19},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":""},{"$f":"MATCH(G4,A:A,0)","v":24},null,null,{"$f":"IF(OR(G25=\"\",H25=\"\"),\"\",INDEX(C:C,MATCH(G25&H25,A:A&B:B,0)))","v":""}]
["Partena","Paul","1955-06-04",{"$f":"IF(COUNTIF($A$2:A26,A26)=1,MAX($D$1:D25)+1,0)","v":20},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":""},null,null,null,{"$f":"IF(OR(G26=\"\",H26=\"\"),\"\",INDEX(C:C,MATCH(G26&H26,A:A&B:B,0)))","v":""}]
["Querty","Pierrette","2000-03-02",{"$f":"IF(COUNTIF($A$2:A27,A27)=1,MAX($D$1:D26)+1,0)","v":21},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":""},null,null,null,{"$f":"IF(OR(G27=\"\",H27=\"\"),\"\",INDEX(C:C,MATCH(G27&H27,A:A&B:B,0)))","v":""}]
["Robino","Paul","1955-06-04",{"$f":"IF(COUNTIF($A$2:A28,A28)=1,MAX($D$1:D27)+1,0)","v":22},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":""},null,null,null,{"$f":"IF(OR(G28=\"\",H28=\"\"),\"\",INDEX(C:C,MATCH(G28&H28,A:A&B:B,0)))","v":""}]
["Rodrigues","Annie","1955-06-04",{"$f":"IF(COUNTIF($A$2:A29,A29)=1,MAX($D$1:D28)+1,0)","v":23},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":""},null,null,null,{"$f":"IF(OR(G29=\"\",H29=\"\"),\"\",INDEX(C:C,MATCH(G29&H29,A:A&B:B,0)))","v":""}]
["Rodrigues","Léa","1955-06-04",{"$f":"IF(COUNTIF($A$2:A30,A30)=1,MAX($D$1:D29)+1,0)","v":0},{"$f":"IF(ROW()<=MAX(D:D),INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":""},null,null,null,{"$f":"IF(OR(G30=\"\",H30=\"\"),\"\",INDEX(C:C,MATCH(G30&H30,A:A&B:B,0)))","v":""}]