{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":2,"comments":1,"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":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["PRENOM","NOM",null,"ANNIVERSAIRE","MARIAGE","DECES",{"$f":"IF(G2>0,G2,TODAY())","v":"2016-12-27"}]
["Benois","VEDIE","2016-07-11","1965-11-18",null,null,"2016-12-27","la date en G2 est prise en compte en G1 en prorité"]
["Bernard","GERVAIS","2016-08-20","1949-07-16",null,null,null,"sinon date d'aujourd'hui automatique en G1"]
["Bernard","GUÉRIN","2016-08-20",null,null,null,{"$f":"MONTH(G1)&\"_\"&DAY(G1)","v":"12_27"}]
["Catherine","LOMBART","2016-11-25","1963-03-04"]
["Charles","BUFFET","2016-11-04","1906-05-01","1931-05-19","1988-07-11"]
["Christophe","BONAPARTE","2016-08-21","1972-10-31",null,null,null,"Le raccourci du fichier est placé dans le dossier démarrage"]
["Colette","TIECHE","2016-03-06","1949-03-10",null,null,null,"FOCTIONNEMENT (on cache le tableau original)"]
["Danielle ","LONGET","2016-09-18","2026-02-17",null,"2009-02-06",null,"Le principe consiste à trouver dans le tableau ci-contre (A1:F22) pour "]
["Jeanne dite FIFINE","ROCARD","2016-02-02",null,null,"1980-06-01",null,"chaque colonne les dates(mois et jour) égales à la date de référence G1"]
["Jean-Paul","YVELIN","2016-12-27","1942-03-16",null,"2008-01-03",null,"(par définition il s'agit de la date  à jour du système! Mais pour les "]
["Jennyfer","LETURC","2016-05-30","2016-01-08",null,null,null," essais n'importe quelle date peut-être utilisée)"]
["Jolan","VANHOUTE","2016-06-25","1994-05-07",null,null,null,"également mois et jour pour afficher à la mise en route du micro, "]
["Joseph","ROCARD","2016-03-19",null,null,"1985-05-15",null,"les prénoms et noms dont les dates coincident (avec un commentaire "]
["Justine","MORALES","2016-03-12","1988-05-06",null,null,null,"approprié à créer pour chaque événement)"]
["Laurent","FORNAN","2016-08-10","1971-01-17",null,null,null,"afin que chacun puisse mettre sa liste à jour, je vais prévoir"]
["Marthe","GASCON","2016-07-29","1937-12-17","1954-04-17",null,null,"un petit formulaire permettant soit d'ajouter soit de retrancher un"]
["Pierre","GASCON","2016-06-29","1935-05-07","1954-04-17",null,null,"individu sans avoir accès au tableau  proprement dit ou ajouter une date"]
["René","GASCON","2016-10-19","1951-02-17",null,"2015-11-09",null,"un mariage ou un décè"]
["Robert","MARTIN","2016-04-30","1937-04-13",null,null,null,"a priori il va peut-être falloire une instruction par colonne"]
["Sabine","BUFFET","2016-08-29","1908-02-21","1931-05-19","2005-11-09"]
["Sarah","ROMAN","1955-12-01","1995-06-28",null,"1995-06-29"]
[]
[]
[]
[]
[]
[null,null,null,null,"J'ai fait des essais avec NB.SI entre autres ça n'a pas marhé non plus"]
[]
[{"$f":"IFERROR(INDEX($A$1:$A$27,LARGE(IF(MONTH($C$2:$C$27)&\"_\"&DAY($C$2:$C$27)=MONTH($G$1)&\"_\"&DAY($G$1),ROW($A$2:$A$27)),ROW(A1))),\"\")","v":"Jean-Paul"}]
[{"$f":"IFERROR(INDEX($A$1:$A$27,LARGE(IF(MONTH($C$2:$C$27)&\"_\"&DAY($C$2:$C$27)=MONTH($G$1)&\"_\"&DAY($G$1),ROW($A$2:$A$27)),ROW(A2))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX($A$1:$A$27,LARGE(IF(MONTH($C$2:$C$27)&\"_\"&DAY($C$2:$C$27)=MONTH($G$1)&\"_\"&DAY($G$1),ROW($A$2:$A$27)),ROW(A3))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX($A$1:$A$27,LARGE(IF(MONTH($C$2:$C$27)&\"_\"&DAY($C$2:$C$27)=MONTH($G$1)&\"_\"&DAY($G$1),ROW($A$2:$A$27)),ROW(A4))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX($A$1:$A$27,LARGE(IF(MONTH($C$2:$C$27)&\"_\"&DAY($C$2:$C$27)=MONTH($G$1)&\"_\"&DAY($G$1),ROW($A$2:$A$27)),ROW(A5))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX($A$1:$A$27,LARGE(IF(MONTH($C$2:$C$27)&\"_\"&DAY($C$2:$C$27)=MONTH($G$1)&\"_\"&DAY($G$1),ROW($A$2:$A$27)),ROW(A6))),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
["=SIERREUR(INDEX($A$1:$A$27;EQUIV(GRANDE.VALEUR(SI(MOIS($B$1:$B$27)&\"_\"&JOUR($B$1:$B$27)=MOIS($F$1)&\"_\"&JOUR($F$1);$B$1:$B$27);LIGNE(A1));$B$1:$B$27;0));\"\")"]

{"sheet":"Feuil2","index":1,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["PRENOM","NOM","FETE","ANNIVERSAIRE","MARIAGE","DECES","FILIATION"]
["Michèle","BENECH GOUSSET"]
["Lulu","CASTELANO"]
["Mégan","CASTELANO"]
["Solène","CASTELANO"]
["Sandrine","CASTELANO FABRIZZI"]
["Bernard","ESCOMEL"]
["Élodie","ESCOMEL"]
["Eric","ESCOMEL"]
["Franky","ESCOMEL"]
["Grégory","ESCOMEL"]
["Jénifer","ESCOMEL"]
["Laurent","ESCOMEL"]
["Loïc","ESCOMEL"]
["Maurice","ESCOMEL"]
["Thomas","ESCOMEL"]
["Yann","ESCOMEL"]
["Sylvie","ESCOMEL COMBE"]
["Odette","ESCOMEL ROUSSET"]
["Eliane","ESCOMEL SCHEFFERT"]
["Catherine","FABRIZZI"]
["Justine","FABRIZZI"]
["Philippe","FABRIZZI"]
["Robert","FABRIZZI"]
["Michelle","FABRIZZI GOUSSET"]
["Elisabeth","FOUREL"]
["Franck","FOUREL"]
["Monique","FOUREL GOUSSET"]
["Mireille","GARCIN"]
["Charles","GOUSSET","2016-11-04","1906-05-01","1931-05-19",null,null,"Par exemple"]
["Christophe","GOUSSET"]
["David","GOUSSET"]
["Evelyne","GOUSSET"]
["Frédéric","GOUSSET"]
["Gérard","GOUSSET"]
["Paul","GOUSSET","1944-06-29","1944-10-09",null,null,null,"Par exemple"]
["Pierre","GOUSSET","2016-06-29","2016-05-07","1954-04-17",null,null,"Par exemple"]
["René","GOUSSET"]
["Severine","GOUSSET"]
["Hélène","GOUSSET ??",null,null,null,null,null,"B-F Frédéric"]
["Sabine","GOUSSET JEAN",null,"1908-02-21","1931-05-19"]
["Marthe","GOUSSET ROUSSET",null,null,"1954-04-17"]
["Sophie","KNUPFER"]
["Jennyfer","LETURC"]
["fabienne","LONGET"]
["Alice","MESLIN"]
["Florence","ROLINAT"]
["Georges","ROUSSET"]
["Joseph","ROUSSET"]
["Jeanne dite FIFINE","ROUSSET MOLARD"]
["Gaelle","TIECHE"]
["Loïc","TIECHE"]
["Marc","TIECHE"]
["Colette","TIECHE GOUSSET"]
["Catherine","VALDER-GOUSSET"]
["Benois","VEDIE"]
["Macha","VEDIE YVELIN"]
["Jean-Paul","YVELIN"]
["Jacqueline","YVELIN GOUSSET"]
["Bernard","GUÉRIN"]
["Dominique","GUÉRIN"]

{"sheet":"Feuil3","index":2,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[41,1,41,3],[42,1,42,3],[43,1,43,3]]}
["Données","Données"]
["pommes",32]
["oranges",54]
["pêches",75]
["pommes",86]
["Formule","Description","Résultat"]
["=NB.SI(A2:A5;\"pommes\")","Nombre de cellules contenant « pommes » dans les cellules A2 à A5.",2]
["=NB.SI(A2:A5;A4)","Nombre de cellules contenant « pêches » dans les cellules A2 à A5.",1]
["=NB.SI(A2:A5,A3)+NB.SI(A2:A5;A2)","Nombre de cellules contenant « oranges » et « pommes » dans les cellules A2 à A5.",3]
["=NB.SI(B2:B5;\">55\")","Nombre de cellules dont la valeur est supérieure à 55 dans les cellules B2 à B5.",2]
["=NB.SI(B2:B5;\"<>\"&B4)","Nombre de cellules dont la valeur n’est pas égale à 75 dans les cellules B2 à B5.",3]
["=NB.SI(B2:B5;\">=32\")-NB.SI(B2:B5;\">85\")","Nombre de cellules dont la valeur est supérieure ou égale à 32 et inférieure ou égale à 85 dans les cellules B2 à B5.",3]
[]
["Exemple 2 : formules NB.SI utilisant des caractères génériques et gérant des valeurs vides"]
["L'exemple sera peut-être plus facile à comprendre si vous le copiez dans une feuille de calcul vide."]
[]
["Données","Données"]
["pommes","Oui"]
[]
["oranges","Non"]
["pêches","Non"]
[]
["pommes","Oui"]
["Formule","Description","Résultat"]
[{"$f":"COUNTIF(A2:A7,\"*es\")","v":4},"Nombre de cellules terminant par les lettres « es » dans les cellules A2 à A7.",4]
[{"$f":"COUNTIF(A2:A7,\"?????es\")","v":1},"Nombre de cellules terminant par les lettres « es » et ayant exactement 7 lettres dans les cellules A2 à A7.",2]
[{"$f":"COUNTIF(A2:A7,\"*\")","v":6},"Nombre de cellules contenant du texte dans les cellules A2 à A7.",4]
[{"$f":"COUNTIF(A2:A7,\"<>\"&\"*\")","v":0},"Nombre de cellules ne contenant pas de texte dans les cellules A2 à A7.",2]
[{"$f":"COUNTIF(B2:B7,\"Non\") / ROWS(B2:B7)","v":0},"Nombre moyen de votes Non (y compris les cellules vides) dans les cellules B2 à B7.","0,333333333"]
[{"$f":"COUNTIF(B2:B7,\"Oui\") / (ROWS(B2:B7) -COUNTIF(B2:B7, \"<>\"&\"*\"))","v":0},"Nombre moyen de votes Oui (sans compter les cellules vides) dans les cellules B2 à B7.","0,5"]
[]
[" Remarque     Pour afficher un nombre sous forme de pourcentage, sélectionnez la cellule, puis cliquez sur Style de pourcentage dans le groupe Nombre de l’onglet Accueil"]
["."]