{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CHOIX","DONNEES","MODE D'EMPLOI"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"CHOIX","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["CHOIX"]
[]
["CONTINENT :","EUROPE"]
["PAYS :","BELGIQUE"]
["VILLE :","BRUXELLES"]

{"sheet":"DONNEES","index":1,"n_rows":203,"n_cols":10,"rows_kept":203,"cut":false,"hidden":false,"merged":[]}
["BASE DE DONNEES",{"$f":"ROWS(T_DONNEES[CONTINENTS])","v":29},"Double clic pour TRI",null,"Liste déroulante CONTINENTS",null,"PAYS","Liste déroulante PAYS",null,"Liste déroulante VILLES"]
["CONTINENTS","PAYS","VILLES",null,"CONTINENTS",null,"PAYS","PAYS s/d",null,"VILLES"]
["AFRIQUE","RDC","KINSHASA"]
["AFRIQUE","RWANDA","KIGALI",null,{"$f":"IFERROR(INDEX(T_DONNEES[CONTINENTS],IF(MIN(IF(COUNTIF($E$3:E3,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2))=0,\"\",MIN(IF(COUNTIF($E$3:E3,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2)))),\"\")","v":"AFRIQUE"},null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:1)),1),\"\")","v":"BELGIQUE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H3,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":"BELGIQUE"},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:1)),1),\"\")","v":"ANTWERPEN"}]
["AMERIQUE CENTRALE","GUATEMALA","GUATEMALA",null,{"$f":"IFERROR(INDEX(T_DONNEES[CONTINENTS],IF(MIN(IF(COUNTIF($E$3:E4,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2))=0,\"\",MIN(IF(COUNTIF($E$3:E4,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2)))),\"\")","v":"AMERIQUE CENTRALE"},null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:2)),1),\"\")","v":"BELGIQUE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H4,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":"ESPAGNE"},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:2)),1),\"\")","v":"BRUXELLES"}]
["AMERIQUE CENTRALE","PANAMA","PANAMA",null,{"$f":"IFERROR(INDEX(T_DONNEES[CONTINENTS],IF(MIN(IF(COUNTIF($E$3:E5,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2))=0,\"\",MIN(IF(COUNTIF($E$3:E5,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2)))),\"\")","v":"AMERIQUE DU NORD"},null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:3)),1),\"\")","v":"BELGIQUE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H5,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":"FRANCE"},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:3)),1),\"\")","v":"CHARLEROI"}]
["AMERIQUE DU NORD","ETATS-UNIS","BOSTON",null,{"$f":"IFERROR(INDEX(T_DONNEES[CONTINENTS],IF(MIN(IF(COUNTIF($E$3:E6,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2))=0,\"\",MIN(IF(COUNTIF($E$3:E6,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2)))),\"\")","v":"AMERIQUE DU SUD"},null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:4)),1),\"\")","v":"BELGIQUE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H6,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":"ITALIE"},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:4)),1),\"\")","v":"GAND"}]
["AMERIQUE DU NORD","ETATS-UNIS","WASHINGTON",null,{"$f":"IFERROR(INDEX(T_DONNEES[CONTINENTS],IF(MIN(IF(COUNTIF($E$3:E7,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2))=0,\"\",MIN(IF(COUNTIF($E$3:E7,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2)))),\"\")","v":"ASIE"},null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:5)),1),\"\")","v":"BELGIQUE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H7,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":"SUISSE"},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:5)),1),\"\")","v":"LIEGE"}]
["AMERIQUE DU SUD","BRESIL","RIO DE JANEIRO",null,{"$f":"IFERROR(INDEX(T_DONNEES[CONTINENTS],IF(MIN(IF(COUNTIF($E$3:E8,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2))=0,\"\",MIN(IF(COUNTIF($E$3:E8,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2)))),\"\")","v":"EUROPE"},null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:6)),1),\"\")","v":"BELGIQUE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H8,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:6)),1),\"\")","v":"NAMUR"}]
["ASIE","CHINE","PEKIN",null,{"$f":"IFERROR(INDEX(T_DONNEES[CONTINENTS],IF(MIN(IF(COUNTIF($E$3:E9,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2))=0,\"\",MIN(IF(COUNTIF($E$3:E9,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2)))),\"\")","v":"OCEANIE"},null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:7)),1),\"\")","v":"ESPAGNE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H9,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:7)),1),\"\")","v":""}]
["ASIE","CHINE","SHANGAI",null,{"$f":"IFERROR(INDEX(T_DONNEES[CONTINENTS],IF(MIN(IF(COUNTIF($E$3:E10,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2))=0,\"\",MIN(IF(COUNTIF($E$3:E10,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2)))),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:8)),1),\"\")","v":"ESPAGNE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H10,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:8)),1),\"\")","v":""}]
["ASIE","JAPON","HIROSHIMA",null,{"$f":"IFERROR(INDEX(T_DONNEES[CONTINENTS],IF(MIN(IF(COUNTIF($E$3:E11,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2))=0,\"\",MIN(IF(COUNTIF($E$3:E11,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2)))),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:9)),1),\"\")","v":"FRANCE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H11,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:9)),1),\"\")","v":""}]
["ASIE","JAPON","NAKASAKI",null,{"$f":"IFERROR(INDEX(T_DONNEES[CONTINENTS],IF(MIN(IF(COUNTIF($E$3:E12,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2))=0,\"\",MIN(IF(COUNTIF($E$3:E12,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2)))),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:10)),1),\"\")","v":"FRANCE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H12,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:10)),1),\"\")","v":""}]
["ASIE","JAPON","TOKIO",null,{"$f":"IFERROR(INDEX(T_DONNEES[CONTINENTS],IF(MIN(IF(COUNTIF($E$3:E13,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2))=0,\"\",MIN(IF(COUNTIF($E$3:E13,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2)))),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:11)),1),\"\")","v":"FRANCE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H13,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:11)),1),\"\")","v":""}]
["EUROPE","BELGIQUE","ANTWERPEN",null,{"$f":"IFERROR(INDEX(T_DONNEES[CONTINENTS],IF(MIN(IF(COUNTIF($E$3:E14,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2))=0,\"\",MIN(IF(COUNTIF($E$3:E14,T_DONNEES[CONTINENTS])=0,ROW(T_DONNEES[CONTINENTS])-2)))),\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:12)),1),\"\")","v":"FRANCE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H14,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:12)),1),\"\")","v":""}]
["EUROPE","BELGIQUE","BRUXELLES",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:13)),1),\"\")","v":"ITALIE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H15,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:13)),1),\"\")","v":""}]
["EUROPE","BELGIQUE","CHARLEROI",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:14)),1),\"\")","v":"ITALIE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H16,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:14)),1),\"\")","v":""}]
["EUROPE","BELGIQUE","GAND",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:15)),1),\"\")","v":"SUISSE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H17,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:15)),1),\"\")","v":""}]
["EUROPE","BELGIQUE","LIEGE",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:16)),1),\"\")","v":"SUISSE"},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H18,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:16)),1),\"\")","v":""}]
["EUROPE","BELGIQUE","NAMUR",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:17)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H19,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:17)),1),\"\")","v":""}]
["EUROPE","ESPAGNE","BARCELONE",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:18)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H20,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:18)),1),\"\")","v":""}]
["EUROPE","ESPAGNE","MADRID",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:19)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H21,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:19)),1),\"\")","v":""}]
["EUROPE","FRANCE","BORDEAU",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:20)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H22,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:20)),1),\"\")","v":""}]
["EUROPE","FRANCE","LILLE",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:21)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H23,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:21)),1),\"\")","v":""}]
["EUROPE","FRANCE","NICE",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:22)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H24,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:22)),1),\"\")","v":""}]
["EUROPE","FRANCE","PARIS",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:23)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H25,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:23)),1),\"\")","v":""}]
["EUROPE","ITALIE","ROME",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:24)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H26,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:24)),1),\"\")","v":""}]
["EUROPE","ITALIE","VENISE",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:25)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H27,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:25)),1),\"\")","v":""}]
["EUROPE","SUISSE","BALE",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:26)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H28,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:26)),1),\"\")","v":""}]
["EUROPE","SUISSE","BERNE",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:27)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H29,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:27)),1),\"\")","v":""}]
["OCEANIE","AUSTRALIE","MELBOURNE",null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:28)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H30,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:28)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:29)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H31,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:29)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:30)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H32,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:30)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:31)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H33,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:31)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:32)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H34,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:32)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:33)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H35,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:33)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:34)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H36,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:34)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:35)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H37,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:35)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:36)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H38,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:36)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:37)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H39,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:37)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:38)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H40,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:38)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:39)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H41,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:39)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:40)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H42,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:40)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:41)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H43,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:41)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:42)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H44,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:42)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:43)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H45,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:43)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:44)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H46,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:44)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:45)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H47,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:45)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:46)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H48,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:46)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:47)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H49,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:47)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:48)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H50,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:48)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:49)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H51,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:49)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:50)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H52,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:50)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:51)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H53,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:51)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:52)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H54,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:52)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:53)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H55,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:53)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:54)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H56,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:54)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:55)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H57,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:55)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:56)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H58,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:56)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:57)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H59,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:57)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:58)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H60,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:58)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:59)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H61,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:59)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:60)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H62,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:60)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:61)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H63,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:61)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:62)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H64,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:62)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:63)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H65,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:63)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:64)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H66,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:64)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:65)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H67,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:65)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:66)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H68,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:66)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:67)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H69,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:67)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:68)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H70,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:68)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:69)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H71,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:69)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:70)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H72,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:70)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:71)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H73,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:71)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:72)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H74,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:72)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:73)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H75,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:73)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:74)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H76,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:74)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:75)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H77,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:75)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:76)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H78,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:76)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:77)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H79,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:77)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:78)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H80,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:78)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:79)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H81,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:79)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:80)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H82,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:80)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:81)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H83,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:81)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:82)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H84,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:82)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:83)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H85,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:83)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:84)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H86,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:84)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:85)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H87,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:85)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:86)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H88,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:86)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:87)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H89,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:87)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:88)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H90,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:88)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:89)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H91,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:89)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:90)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H92,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:90)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:91)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H93,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:91)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:92)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H94,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:92)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:93)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H95,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:93)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:94)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H96,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:94)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:95)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H97,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:95)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:96)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H98,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:96)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:97)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H99,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:97)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:98)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H100,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:98)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:99)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H101,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:99)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:100)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H102,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:100)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:101)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H103,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:101)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:102)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H104,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:102)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:103)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H105,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:103)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:104)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H106,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:104)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:105)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H107,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:105)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:106)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H108,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:106)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:107)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H109,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:107)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:108)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H110,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:108)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:109)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H111,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:109)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:110)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H112,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:110)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:111)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H113,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:111)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:112)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H114,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:112)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:113)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H115,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:113)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:114)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H116,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:114)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:115)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H117,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:115)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:116)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H118,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:116)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:117)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H119,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:117)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:118)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H120,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:118)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:119)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H121,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:119)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:120)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H122,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:120)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:121)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H123,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:121)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:122)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H124,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:122)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:123)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H125,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:123)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:124)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H126,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:124)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:125)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H127,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:125)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:126)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H128,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:126)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:127)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H129,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:127)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:128)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H130,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:128)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:129)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H131,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:129)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:130)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H132,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:130)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:131)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H133,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:131)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:132)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H134,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:132)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:133)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H135,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:133)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:134)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H136,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:134)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:135)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H137,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:135)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:136)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H138,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:136)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:137)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H139,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:137)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:138)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H140,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:138)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:139)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H141,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:139)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:140)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H142,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:140)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:141)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H143,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:141)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:142)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H144,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:142)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:143)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H145,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:143)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:144)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H146,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:144)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:145)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H147,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:145)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:146)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H148,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:146)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:147)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H149,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:147)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:148)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H150,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:148)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:149)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H151,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:149)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:150)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H152,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:150)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:151)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H153,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:151)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:152)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H154,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:152)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:153)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H155,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:153)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:154)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H156,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:154)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:155)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H157,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:155)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:156)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H158,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:156)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:157)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H159,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:157)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:158)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H160,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:158)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:159)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H161,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:159)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:160)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H162,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:160)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:161)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H163,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:161)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:162)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H164,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:162)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:163)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H165,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:163)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:164)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H166,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:164)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:165)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H167,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:165)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:166)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H168,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:166)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:167)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H169,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:167)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:168)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H170,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:168)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:169)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H171,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:169)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:170)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H172,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:170)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:171)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H173,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:171)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:172)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H174,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:172)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:173)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H175,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:173)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:174)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H176,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:174)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:175)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H177,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:175)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:176)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H178,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:176)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:177)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H179,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:177)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:178)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H180,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:178)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:179)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H181,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:179)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:180)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H182,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:180)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:181)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H183,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:181)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:182)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H184,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:182)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:183)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H185,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:183)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:184)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H186,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:184)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:185)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H187,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:185)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:186)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H188,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:186)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:187)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H189,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:187)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:188)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H190,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:188)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:189)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H191,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:189)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:190)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H192,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:190)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:191)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H193,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:191)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:192)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H194,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:192)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:193)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H195,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:193)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:194)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H196,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:194)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:195)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H197,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:195)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:196)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H198,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:196)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:197)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H199,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:197)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:198)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H200,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:198)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:199)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H201,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:199)),1),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(T_DONNEES[PAYS],SMALL(IF(T_DONNEES[CONTINENTS]=L_CONTINENTS,ROW(T_DONNEES[PAYS])-2),ROWS($1:200)),1),\"\")","v":""},{"$f":"(INDEX($G$3:$G$203,MIN(IF(COUNTIF($H$3:H202,$G$4:$G$203)=0,ROW($G$4:$G$203)-2)))&\"\")","v":""},null,{"$f":"IFERROR(INDEX(T_DONNEES[VILLES],SMALL(IF(T_DONNEES[PAYS]=L_PAYS,ROW(T_DONNEES[PAYS])-2),ROWS($1:200)),1),\"\")","v":""}]

{"sheet":"MODE D'EMPLOI","index":2,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["MODE D'EMPLOI"]
[0,"Description"]
[null,"L'application permet de construire des listes déroulantes permettant de faire des choix en cascade à partir des Continents ou Régions importantes de notre planète pour accéder ensuite aux Pays composants ces Continents ou Régions et enfin les Villes de ces Pays ou Région"]
[null,"La construction de ces listes se fait dans l'onglet DONNEES et, pour plus de faciliter dans la construction des formules ainsi que pour permettre une évolution aisée du nombre de DONNEES, l'ensemble des Tableaux construisant les listes a été construit sous forme de Tableau Structuré (TS)."]
[]
[1,"Premier Tableau structuré : T_DONNEES"]
[null,"Contient les DONNEES de base à savoir : \nCONTINENTS - PAYS - VILLES.\nCe tableau est évolutif càd que l'Opérateur peut ajouter autant de lignes que nécessaire. Il suffit de se positionner dans la dernière cellule du Tableau et de fait \" TAB \" --> le Tableau s'augmentera automatiquement d'une ligne ET TOUTES LES FORMULES S'ADAPTERONT AUTOMATIQUEMENT\nUn double clic dans le Tableau provoquera la mise en route d'un VBA qui triera le Tableau par CONTINENTS - PAYS - VILLES et positionnera le curseur dans la dernière cellule du Tableau càd prêt pour une nouvelle introduction.\nEn B1 se trouve le calcul du nombre de lignes du Tableau."]
[2,"Deuxième Tableau structuré : T_CONTINENTS"]
[null,"Ce Tableau est limité à 12 lignes dont une ligne \"vide\" et est construit automatiquement à partir du Tableau T_DONNEES.\nLa formule qui extrait les CONTINENTS sans doublons est une formule matricielle.  Il faut donc l'introduire SANS les { } et en appuyant simultanément sur CTRL et ENTREE.  Excel ajoutera automatiquement les { } pour indiquer qu'il s'agit d'une formule matricielle càd que les plages impliquées dans la formule seront considérées comme des matrices."]
[3,"Troisième Tableau structuré : T_PAYS"]
[null,"Ce Tableau est limité à 201 lignes dont une ligne \"vide\" et est construit automatiquement à partir du Tableau T_DONNEES et du choix du CONTINENTS effectué dans l'onglet CHOIX en B3.\nLa construction de la liste se fait en 2 temps :\n- extraction de tous les pays appartenant au CONTINENT choisi\n- élimination des doublons pour ne pas surcharger la liste déroulante\nLes formules sont également matricielles"]
[4,"Quatrième Tableau structuré : T_VILLES"]
[null,"Ce Tableau est limité à 201 lignes dont une ligne \"vide\" et est construit automatiquement à partir du Tableau T_DONNEES et du choix du PAYS effectué dans l'onglet CHOIX en B4.\nA noter que si l'Opérateur introduit plusieurs fois la même ville dans la Base de DONNEES...il y aura plusieurs fois la ville dans la liste déroulante mais cela ne devrait pas arriver car cela n'a aucun sens logique et ne peut donc être qu'une erreur à corriger."]
[5,"Onglet CHOIX"]
[null,"Cet onglet permet de faire les CHOIX et donc devrait être remplacé par l'onglet répondant à l'application qui a besoin de ces choix et dans laquelle il faudra implanter les listes.\nIl faudra aussi impérativement NOMME les cellules contenant ces listes par les Noms suivants : L_CONTINENTS ; L_PAYS ; L_VILLES.\nAinsi les formules iront chercher les CHOIX au bon endroit et l'application s'adaptera automatiquement."]
[null,"A noter : cet onglet contient un petit VBA qui réinitialise automatiquement les choix dès que l'Opérateur sélectionne un des 3 choix.  Si l'on veut conserver ce petit utilitaire très pratique, il faudra, bien entendu, l'introduire dans le VBA de l'onglet définitif et en rectifiant l'adresse des cellules concernées :\n\nPrivate Sub Worksheet_SelectionChange(ByVal Target As Range)\nIf Target.Address = \"$B$3\" Then\nRange(\"B3:B5\").ClearContents\nEnd If\nIf Target.Address = \"$B$4\" Then\nRange(\"B4:B5\").ClearContents\nEnd If\nEnd Sub\n"]