{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["F_1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"F_1","index":0,"n_rows":101,"n_cols":11,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,null,"vérif"]
["Paul","Léa",{"$f":"IF(COUNTIF($A$1:$A$16,B2),1,0)","v":1},{"$f":"SUMPRODUCT((COUNTIF(B2:B101,A2:A16)*1))","v":60},"<résultat nombre de valeurs de A2:A15 de B2 à B500/ formule directe"]
["Marcel","Josette",{"$f":"IF(COUNTIF($A$1:$A$16,B3),1,0)","v":0}]
["André","Frédéric",{"$f":"IF(COUNTIF($A$1:$A$16,B4),1,0)","v":1}]
["Kevin","Eric",{"$f":"IF(COUNTIF($A$1:$A$16,B5),1,0)","v":1},{"$f":"SUM(C2:C101)","v":60},"somme colonne vérification"]
["Simone","Léa",{"$f":"IF(COUNTIF($A$1:$A$16,B6),1,0)","v":1}]
["Léa","Pierrette",{"$f":"IF(COUNTIF($A$1:$A$16,B7),1,0)","v":0}]
["Lucas","Kevin",{"$f":"IF(COUNTIF($A$1:$A$16,B8),1,0)","v":1}]
["Eric","Chrystel",{"$f":"IF(COUNTIF($A$1:$A$16,B9),1,0)","v":0},null,null,null,null,null,null,null,false]
["Gilles","Eugénie",{"$f":"IF(COUNTIF($A$1:$A$16,B10),1,0)","v":0}]
["Jacqueline","Corinne",{"$f":"IF(COUNTIF($A$1:$A$16,B11),1,0)","v":0}]
["Monique","Paul",{"$f":"IF(COUNTIF($A$1:$A$16,B12),1,0)","v":1}]
["Claude","Jean",{"$f":"IF(COUNTIF($A$1:$A$16,B13),1,0)","v":0}]
["Michel","André",{"$f":"IF(COUNTIF($A$1:$A$16,B14),1,0)","v":1}]
["Chantal","Monique",{"$f":"IF(COUNTIF($A$1:$A$16,B15),1,0)","v":1}]
["Frédéric","Gilles",{"$f":"IF(COUNTIF($A$1:$A$16,B16),1,0)","v":1}]
[null,"Simone",{"$f":"IF(COUNTIF($A$1:$A$16,B17),1,0)","v":1}]
[null,"Kevin",{"$f":"IF(COUNTIF($A$1:$A$16,B18),1,0)","v":1}]
[null,"Claude",{"$f":"IF(COUNTIF($A$1:$A$16,B19),1,0)","v":1}]
[null,"Paul",{"$f":"IF(COUNTIF($A$1:$A$16,B20),1,0)","v":1}]
[null,"Frédéric",{"$f":"IF(COUNTIF($A$1:$A$16,B21),1,0)","v":1}]
[null,"Chantal",{"$f":"IF(COUNTIF($A$1:$A$16,B22),1,0)","v":1}]
[null,"Chrystel",{"$f":"IF(COUNTIF($A$1:$A$16,B23),1,0)","v":0}]
[null,"Gilles",{"$f":"IF(COUNTIF($A$1:$A$16,B24),1,0)","v":1}]
[null,"Simone",{"$f":"IF(COUNTIF($A$1:$A$16,B25),1,0)","v":1}]
[null,"Lucas",{"$f":"IF(COUNTIF($A$1:$A$16,B26),1,0)","v":1}]
[null,"Paul",{"$f":"IF(COUNTIF($A$1:$A$16,B27),1,0)","v":1}]
[null,"Jacques",{"$f":"IF(COUNTIF($A$1:$A$16,B28),1,0)","v":0}]
[null,"Eric",{"$f":"IF(COUNTIF($A$1:$A$16,B29),1,0)","v":1}]
[null,"Chantal",{"$f":"IF(COUNTIF($A$1:$A$16,B30),1,0)","v":1}]
[null,"Corinne",{"$f":"IF(COUNTIF($A$1:$A$16,B31),1,0)","v":0}]
[null,"Josette",{"$f":"IF(COUNTIF($A$1:$A$16,B32),1,0)","v":0}]
[null,"Roger",{"$f":"IF(COUNTIF($A$1:$A$16,B33),1,0)","v":0}]
[null,"Frédéric",{"$f":"IF(COUNTIF($A$1:$A$16,B34),1,0)","v":1}]
[null,"Eugénie",{"$f":"IF(COUNTIF($A$1:$A$16,B35),1,0)","v":0}]
[null,"Claude",{"$f":"IF(COUNTIF($A$1:$A$16,B36),1,0)","v":1}]
[null,"Lucas",{"$f":"IF(COUNTIF($A$1:$A$16,B37),1,0)","v":1}]
[null,"Léa",{"$f":"IF(COUNTIF($A$1:$A$16,B38),1,0)","v":1}]
[null,"Pierrette",{"$f":"IF(COUNTIF($A$1:$A$16,B39),1,0)","v":0}]
[null,"Annie",{"$f":"IF(COUNTIF($A$1:$A$16,B40),1,0)","v":0}]
[null,"Claude",{"$f":"IF(COUNTIF($A$1:$A$16,B41),1,0)","v":1}]
[null,"Corinne",{"$f":"IF(COUNTIF($A$1:$A$16,B42),1,0)","v":0}]
[null,"Chrystel",{"$f":"IF(COUNTIF($A$1:$A$16,B43),1,0)","v":0}]
[null,"Michel",{"$f":"IF(COUNTIF($A$1:$A$16,B44),1,0)","v":1}]
[null,"Jacqueline",{"$f":"IF(COUNTIF($A$1:$A$16,B45),1,0)","v":1}]
[null,"Josette",{"$f":"IF(COUNTIF($A$1:$A$16,B46),1,0)","v":0}]
[null,"Jacques",{"$f":"IF(COUNTIF($A$1:$A$16,B47),1,0)","v":0}]
[null,"Monique",{"$f":"IF(COUNTIF($A$1:$A$16,B48),1,0)","v":1}]
[null,"Pierrette",{"$f":"IF(COUNTIF($A$1:$A$16,B49),1,0)","v":0}]
[null,"Eric",{"$f":"IF(COUNTIF($A$1:$A$16,B50),1,0)","v":1}]
[null,"Annie",{"$f":"IF(COUNTIF($A$1:$A$16,B51),1,0)","v":0}]
[null,"Jean",{"$f":"IF(COUNTIF($A$1:$A$16,B52),1,0)","v":0}]
[null,"Pierrette",{"$f":"IF(COUNTIF($A$1:$A$16,B53),1,0)","v":0}]
[null,"Eugénie",{"$f":"IF(COUNTIF($A$1:$A$16,B54),1,0)","v":0}]
[null,"Eugénie",{"$f":"IF(COUNTIF($A$1:$A$16,B55),1,0)","v":0}]
[null,"Marcel",{"$f":"IF(COUNTIF($A$1:$A$16,B56),1,0)","v":1}]
[null,"Jacqueline",{"$f":"IF(COUNTIF($A$1:$A$16,B57),1,0)","v":1}]
[null,"Pierre",{"$f":"IF(COUNTIF($A$1:$A$16,B58),1,0)","v":0}]
[null,"Annette",{"$f":"IF(COUNTIF($A$1:$A$16,B59),1,0)","v":0}]
[null,"Gilles",{"$f":"IF(COUNTIF($A$1:$A$16,B60),1,0)","v":1}]
[null,"Monique",{"$f":"IF(COUNTIF($A$1:$A$16,B61),1,0)","v":1}]
[null,"Roger",{"$f":"IF(COUNTIF($A$1:$A$16,B62),1,0)","v":0}]
[null,"Pierre",{"$f":"IF(COUNTIF($A$1:$A$16,B63),1,0)","v":0}]
[null,"Chantal",{"$f":"IF(COUNTIF($A$1:$A$16,B64),1,0)","v":1}]
[null,"Marcel",{"$f":"IF(COUNTIF($A$1:$A$16,B65),1,0)","v":1}]
[null,"Jean",{"$f":"IF(COUNTIF($A$1:$A$16,B66),1,0)","v":0}]
[null,"Paul",{"$f":"IF(COUNTIF($A$1:$A$16,B67),1,0)","v":1}]
[null,"Corinne",{"$f":"IF(COUNTIF($A$1:$A$16,B68),1,0)","v":0}]
[null,"Claude",{"$f":"IF(COUNTIF($A$1:$A$16,B69),1,0)","v":1}]
[null,"Eric",{"$f":"IF(COUNTIF($A$1:$A$16,B70),1,0)","v":1}]
[null,"Annette",{"$f":"IF(COUNTIF($A$1:$A$16,B71),1,0)","v":0}]
[null,"Jacques",{"$f":"IF(COUNTIF($A$1:$A$16,B72),1,0)","v":0}]
[null,"Annette",{"$f":"IF(COUNTIF($A$1:$A$16,B73),1,0)","v":0}]
[null,"Marcel",{"$f":"IF(COUNTIF($A$1:$A$16,B74),1,0)","v":1}]
[null,"Lucas",{"$f":"IF(COUNTIF($A$1:$A$16,B75),1,0)","v":1}]
[null,"Annie",{"$f":"IF(COUNTIF($A$1:$A$16,B76),1,0)","v":0}]
[null,"Monique",{"$f":"IF(COUNTIF($A$1:$A$16,B77),1,0)","v":1}]
[null,"Simone",{"$f":"IF(COUNTIF($A$1:$A$16,B78),1,0)","v":1}]
[null,"Pierre",{"$f":"IF(COUNTIF($A$1:$A$16,B79),1,0)","v":0}]
[null,"Kevin",{"$f":"IF(COUNTIF($A$1:$A$16,B80),1,0)","v":1}]
[null,"Marcel",{"$f":"IF(COUNTIF($A$1:$A$16,B81),1,0)","v":1}]
[null,"Michel",{"$f":"IF(COUNTIF($A$1:$A$16,B82),1,0)","v":1}]
[null,"Michel",{"$f":"IF(COUNTIF($A$1:$A$16,B83),1,0)","v":1}]
[null,"Jacques",{"$f":"IF(COUNTIF($A$1:$A$16,B84),1,0)","v":0}]
[null,"Roger",{"$f":"IF(COUNTIF($A$1:$A$16,B85),1,0)","v":0}]
[null,"Chrystel",{"$f":"IF(COUNTIF($A$1:$A$16,B86),1,0)","v":0}]
[null,"André",{"$f":"IF(COUNTIF($A$1:$A$16,B87),1,0)","v":1}]
[null,"Jacqueline",{"$f":"IF(COUNTIF($A$1:$A$16,B88),1,0)","v":1}]
[null,"Jean",{"$f":"IF(COUNTIF($A$1:$A$16,B89),1,0)","v":0}]
[null,"André",{"$f":"IF(COUNTIF($A$1:$A$16,B90),1,0)","v":1}]
[null,"Josette",{"$f":"IF(COUNTIF($A$1:$A$16,B91),1,0)","v":0}]
[null,"Kevin",{"$f":"IF(COUNTIF($A$1:$A$16,B92),1,0)","v":1}]
[null,"Lucas",{"$f":"IF(COUNTIF($A$1:$A$16,B93),1,0)","v":1}]
[null,"André",{"$f":"IF(COUNTIF($A$1:$A$16,B94),1,0)","v":1}]
[null,"Simone",{"$f":"IF(COUNTIF($A$1:$A$16,B95),1,0)","v":1}]
[null,"Jacqueline",{"$f":"IF(COUNTIF($A$1:$A$16,B96),1,0)","v":1}]
[null,"Léa",{"$f":"IF(COUNTIF($A$1:$A$16,B97),1,0)","v":1}]
[null,"Michel",{"$f":"IF(COUNTIF($A$1:$A$16,B98),1,0)","v":1}]
[null,"Chantal",{"$f":"IF(COUNTIF($A$1:$A$16,B99),1,0)","v":1}]
[null,"Frédéric",{"$f":"IF(COUNTIF($A$1:$A$16,B100),1,0)","v":1}]
[null,"Gilles",{"$f":"IF(COUNTIF($A$1:$A$16,B101),1,0)","v":1}]