{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil2"],"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":70,"n_cols":3,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"A"]
[null,null,"B"]
[null,null,"C"]
[]
[]
[null,null,"F"]
[null,null,"G"]
[null,null,"H"]
[null,null,"I"]
[null,null,"J"]
[null,null,"K"]
[null,null,"L"]
[null,null,"M"]
[]
[null,null,"O"]
[null,null,"P"]
[null,null,"Q"]
[null,null,"R"]
[null,null,"S"]
[null,null,"T"]
[]
[null,null,"V"]
[]
[]
[]
[null,null,"Z"]
[null,null,"alpha"]
[null,null,"A"]
[null,null,"B"]
[null,null,"C"]
[null,null,"D"]
[]
[null,null,"F"]
[null,null,"G"]
[null,null,"H"]
[null,null,"I"]
[null,null,"J"]
[null,null,"K"]
[null,null,"L"]
[null,null,"M"]
[null,null,"N"]
[null,null,"O"]
[null,null,"P"]
[null,null,"Q"]
[]
[]
[]
[null,null,"U"]
[null,null,"V"]
[null,null,"W"]
[null,null,"X"]
[null,null,"Y"]
[null,null,"Z"]
[null,null,"alpha"]
[null,null,"A"]
[]
[]
[null,null,"D"]
[null,null,"E"]
[null,null,"F"]
[null,null,"G"]
[null,null,"H"]
[null,null,"I"]
[null,null,"J"]
[null,null,"K"]
[null,null,"L"]
[null,null,"M"]

{"sheet":"Feuil2","index":1,"n_rows":18,"n_cols":67,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"solution sur ligne 2 élimine les cellules vides de la colonne C de feuil1"]
[]
[null,null,null,null,{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(A$1)),3,,,\"Feuil1\")),\"\")","v":"A"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(B$1)),3,,,\"Feuil1\")),\"\")","v":"B"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(C$1)),3,,,\"Feuil1\")),\"\")","v":"C"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(D$1)),3,,,\"Feuil1\")),\"\")","v":"F"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(E$1)),3,,,\"Feuil1\")),\"\")","v":"G"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(F$1)),3,,,\"Feuil1\")),\"\")","v":"H"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(G$1)),3,,,\"Feuil1\")),\"\")","v":"I"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(H$1)),3,,,\"Feuil1\")),\"\")","v":"J"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(I$1)),3,,,\"Feuil1\")),\"\")","v":"K"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(J$1)),3,,,\"Feuil1\")),\"\")","v":"L"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(K$1)),3,,,\"Feuil1\")),\"\")","v":"M"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(L$1)),3,,,\"Feuil1\")),\"\")","v":"O"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(M$1)),3,,,\"Feuil1\")),\"\")","v":"P"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(N$1)),3,,,\"Feuil1\")),\"\")","v":"Q"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(O$1)),3,,,\"Feuil1\")),\"\")","v":"R"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(P$1)),3,,,\"Feuil1\")),\"\")","v":"S"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(Q$1)),3,,,\"Feuil1\")),\"\")","v":"T"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(R$1)),3,,,\"Feuil1\")),\"\")","v":"V"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(S$1)),3,,,\"Feuil1\")),\"\")","v":"Z"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(T$1)),3,,,\"Feuil1\")),\"\")","v":"alpha"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(U$1)),3,,,\"Feuil1\")),\"\")","v":"A"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(V$1)),3,,,\"Feuil1\")),\"\")","v":"B"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(W$1)),3,,,\"Feuil1\")),\"\")","v":"C"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(X$1)),3,,,\"Feuil1\")),\"\")","v":"D"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(Y$1)),3,,,\"Feuil1\")),\"\")","v":"F"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(Z$1)),3,,,\"Feuil1\")),\"\")","v":"G"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AA$1)),3,,,\"Feuil1\")),\"\")","v":"H"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AB$1)),3,,,\"Feuil1\")),\"\")","v":"I"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AC$1)),3,,,\"Feuil1\")),\"\")","v":"J"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AD$1)),3,,,\"Feuil1\")),\"\")","v":"K"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AE$1)),3,,,\"Feuil1\")),\"\")","v":"L"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AF$1)),3,,,\"Feuil1\")),\"\")","v":"M"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AG$1)),3,,,\"Feuil1\")),\"\")","v":"N"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AH$1)),3,,,\"Feuil1\")),\"\")","v":"O"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AI$1)),3,,,\"Feuil1\")),\"\")","v":"P"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AJ$1)),3,,,\"Feuil1\")),\"\")","v":"Q"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AK$1)),3,,,\"Feuil1\")),\"\")","v":"U"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AL$1)),3,,,\"Feuil1\")),\"\")","v":"V"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AM$1)),3,,,\"Feuil1\")),\"\")","v":"W"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AN$1)),3,,,\"Feuil1\")),\"\")","v":"X"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AO$1)),3,,,\"Feuil1\")),\"\")","v":"Y"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AP$1)),3,,,\"Feuil1\")),\"\")","v":"Z"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AQ$1)),3,,,\"Feuil1\")),\"\")","v":"alpha"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AR$1)),3,,,\"Feuil1\")),\"\")","v":"A"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AS$1)),3,,,\"Feuil1\")),\"\")","v":"D"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AT$1)),3,,,\"Feuil1\")),\"\")","v":"E"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AU$1)),3,,,\"Feuil1\")),\"\")","v":"F"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AV$1)),3,,,\"Feuil1\")),\"\")","v":"G"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AW$1)),3,,,\"Feuil1\")),\"\")","v":"H"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AX$1)),3,,,\"Feuil1\")),\"\")","v":"I"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AY$1)),3,,,\"Feuil1\")),\"\")","v":"J"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(AZ$1)),3,,,\"Feuil1\")),\"\")","v":"K"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(BA$1)),3,,,\"Feuil1\")),\"\")","v":"L"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(BB$1)),3,,,\"Feuil1\")),\"\")","v":"M"},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(BC$1)),3,,,\"Feuil1\")),\"\")","v":""},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(BD$1)),3,,,\"Feuil1\")),\"\")","v":""},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(BE$1)),3,,,\"Feuil1\")),\"\")","v":""},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(BF$1)),3,,,\"Feuil1\")),\"\")","v":""},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(BG$1)),3,,,\"Feuil1\")),\"\")","v":""},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(BH$1)),3,,,\"Feuil1\")),\"\")","v":""},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(BI$1)),3,,,\"Feuil1\")),\"\")","v":""},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(BJ$1)),3,,,\"Feuil1\")),\"\")","v":""},{"$f":"IFERROR(INDIRECT(ADDRESS(SMALL(IF(Feuil1!$C$4:$C$100<>\"\",ROW($A$4:$A$100)),COLUMN(BK$1)),3,,,\"Feuil1\")),\"\")","v":""}]
[]
[]
[null,null,null,null,"attention"]
[null,null,null,null,"la formule est matricielle et doit être entrée avec  la touche enter en maintenant les touches ctrl et shift enfoncées"]
[null,null,null,null,"elle doit s'afficher entre accolades automatiquement dans la barre de formule"]
[]
[null,null,null,null,"cette formule élimine les valeurs 0 de la liste en C de >Feuil1"]
[null,null,null,null,"elle est assez gourmande en capacité, bien limiter les champs au nombre de lignes et de colonnes utiles pour ne pas charger le fichier"]
[]
[]
[null,null,null,null,"solution sur ligne 16 renvoie toutes les cellules (plus simple et moins lourd dans le fichier)"]
[]
[null,null,null,null,{"$f":"INDIRECT(ADDRESS(COLUMN(D$1),3,,,\"Feuil1\"))","v":"A"},{"$f":"INDIRECT(ADDRESS(COLUMN(E$1),3,,,\"Feuil1\"))","v":"B"},"C",0,0,"F","G","H","I","J","K","L","M",0,"O","P","Q","R","S","T",0,"V",0,0,0,"Z","alpha","A","B","C","D",0,"F","G","H","I","J","K","L","M","N","O","P","Q",0,0,0,"U","V","W","X","Y","Z","alpha","A",0,0,"D","E","F","G","H","I"]
[]
[null,null,null,null,"l'affichage des 0 est décoché dans les options Excel"]