{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"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":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Nom joueurs","Nom du club","score","Les plus grands résultats","Nom des joueurs ayant obtenu ces résultats","Nom des clubs de ces joueurs","Une autre formule pour trouver le nom des clubs"]
["toto1","Titi1",1,{"$f":"LARGE($C$2:$C$21,ROW(A1))","v":78},{"$f":"INDEX($A$1:$A$21,SMALL(IF(RG=D2,ROW(RG)),COUNTIF($D$2:$D2,D2)))","v":"toto6"},{"$f":"INDEX($B$1:$B$21,SMALL(IF(RG=D2,ROW(RG)),COUNTIF($D$2:$D2,D2)))","v":"Titi6"},{"$f":"INDEX($B$1:$B$21,MATCH(E2,$A$1:$A$21,0))","v":"Titi6"}]
["toto2","Titi2",2,{"$f":"LARGE($C$2:$C$21,ROW(A2))","v":78},{"$f":"INDEX($A$1:$A$21,SMALL(IF(RG=D3,ROW(RG)),COUNTIF($D$2:$D3,D3)))","v":"toto11"},{"$f":"INDEX($B$1:$B$21,SMALL(IF(RG=D3,ROW(RG)),COUNTIF($D$2:$D3,D3)))","v":"Titi11"},{"$f":"INDEX($B$1:$B$21,MATCH(E3,$A$1:$A$21,0))","v":"Titi11"}]
["toto3","Titi3",5,{"$f":"LARGE($C$2:$C$21,ROW(A3))","v":78},{"$f":"INDEX($A$1:$A$21,SMALL(IF(RG=D4,ROW(RG)),COUNTIF($D$2:$D4,D4)))","v":"toto17"},{"$f":"INDEX($B$1:$B$21,SMALL(IF(RG=D4,ROW(RG)),COUNTIF($D$2:$D4,D4)))","v":"Titi17"},"Titi17"]
["toto4","Titi4",63,{"$f":"LARGE($C$2:$C$21,ROW(A4))","v":78},{"$f":"INDEX($A$1:$A$21,SMALL(IF(RG=D5,ROW(RG)),COUNTIF($D$2:$D5,D5)))","v":"toto19"},{"$f":"INDEX($B$1:$B$21,SMALL(IF(RG=D5,ROW(RG)),COUNTIF($D$2:$D5,D5)))","v":"Titi19"},"Titi19"]
["toto5","Titi5",2,{"$f":"LARGE($C$2:$C$21,ROW(A5))","v":72},{"$f":"INDEX($A$1:$A$21,SMALL(IF(RG=D6,ROW(RG)),COUNTIF($D$2:$D6,D6)))","v":"toto12"},{"$f":"INDEX($B$1:$B$21,SMALL(IF(RG=D6,ROW(RG)),COUNTIF($D$2:$D6,D6)))","v":"Titi12"},"Titi12"]
["toto6","Titi6",78]
["toto7","Titi7",1]
["toto8","Titi8",9,"Si tu désires obtenir les 5 plus petits résultats :"]
["toto9","Titi9",7,"Les plus petits résultats","Nom des jours ","Nom des clubs de ces joueurs","Une autre formule pour trouver le nom des clubs"]
["toto10","Titi10",2,{"$f":"SMALL($C$2:$C$21,ROW(A1))","v":1},{"$f":"INDEX($A$1:$A$21,SMALL(IF(RG=D11,ROW(RG)),COUNTIF($D$11:$D11,D11)))","v":"toto1"},{"$f":"INDEX($B$1:$B$21,SMALL(IF(RG=D11,ROW(RG)),COUNTIF($D$11:$D11,D11)))","v":"Titi1"},{"$f":"INDEX($B$1:$B$21,MATCH(E11,$A$1:$A$21,0))","v":"Titi1"}]
["toto11","Titi11",78,{"$f":"SMALL($C$2:$C$21,ROW(A2))","v":1},{"$f":"INDEX($A$1:$A$21,SMALL(IF(RG=D12,ROW(RG)),COUNTIF($D$11:$D12,D12)))","v":"toto7"},{"$f":"INDEX($B$1:$B$21,SMALL(IF(RG=D12,ROW(RG)),COUNTIF($D$11:$D12,D12)))","v":"Titi7"},{"$f":"INDEX($B$1:$B$21,MATCH(E12,$A$1:$A$21,0))","v":"Titi7"}]
["toto12","Titi12",72,{"$f":"SMALL($C$2:$C$21,ROW(A3))","v":2},{"$f":"INDEX($A$1:$A$21,SMALL(IF(RG=D13,ROW(RG)),COUNTIF($D$11:$D13,D13)))","v":"toto2"},{"$f":"INDEX($B$1:$B$21,SMALL(IF(RG=D13,ROW(RG)),COUNTIF($D$11:$D13,D13)))","v":"Titi2"},{"$f":"INDEX($B$1:$B$21,MATCH(E13,$A$1:$A$21,0))","v":"Titi2"}]
["toto13","Titi13",65,{"$f":"SMALL($C$2:$C$21,ROW(A4))","v":2},{"$f":"INDEX($A$1:$A$21,SMALL(IF(RG=D14,ROW(RG)),COUNTIF($D$11:$D14,D14)))","v":"toto5"},{"$f":"INDEX($B$1:$B$21,SMALL(IF(RG=D14,ROW(RG)),COUNTIF($D$11:$D14,D14)))","v":"Titi5"},{"$f":"INDEX($B$1:$B$21,MATCH(E14,$A$1:$A$21,0))","v":"Titi5"}]
["toto14","Titi14",4,{"$f":"SMALL($C$2:$C$21,ROW(A5))","v":2},{"$f":"INDEX($A$1:$A$21,SMALL(IF(RG=D15,ROW(RG)),COUNTIF($D$11:$D15,D15)))","v":"toto10"},{"$f":"INDEX($B$1:$B$21,SMALL(IF(RG=D15,ROW(RG)),COUNTIF($D$11:$D15,D15)))","v":"Titi10"},{"$f":"INDEX($B$1:$B$21,MATCH(E15,$A$1:$A$21,0))","v":"Titi10"}]
["toto15","Titi15",52]
["toto16","Titi16",69]
["toto17","Titi17",78]
["toto18","Titi18",54]
["toto19","Titi19",78]
["toto20","Titi20",32]