{"id":4970,"date":"2025-10-30T11:28:00","date_gmt":"2025-10-30T10:28:00","guid":{"rendered":"https:\/\/people.unil.ch\/jacquelinefrey\/?p=4970"},"modified":"2025-10-30T11:30:12","modified_gmt":"2025-10-30T10:30:12","slug":"excel-365-decompter-des-colonnes","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2025\/10\/excel-365-decompter-des-colonnes\/","title":{"rendered":"Excel 365 – D\u00e9compter des colonnes"},"content":{"rendered":"\n

Contexte<\/h3>\n\n\n\n

Vous avez export\u00e9 les 13’457 enregistrements provenant d’une base de donn\u00e9es FileMaker (ou autres). Vous avez choisi d’exporter les 375 rubriques contenues dans la table. <\/p>\n\n\n\n

Arriv\u00e9 dans Excel, vous avez un doute sur le r\u00e9sultat de l’exportation : \u00ab\u00a0est-ce que les 13’457 enregistrements des 375 rubriques ont bien \u00e9t\u00e9 export\u00e9s ?\u00a0\u00bb Les lignes dans Excel sont num\u00e9rot\u00e9es il est donc facile de v\u00e9rifier mais les colonnes quant \u00e0 elles affichent des lettres…<\/p>\n\n\n\n

3 Solutions possibles<\/h3>\n\n\n\n
    \n
  1. Apr\u00e8s la derni\u00e8re colonne (nomm\u00e9e NL dans mon exemple), tapez la formule suivante : =Colonnes(A1:NK1). Le r\u00e9sultat doit \u00eatre 375<\/li>\n\n\n\n
  2. ou s\u00e9lectionnez la plage allant de A1 \u00e0 NK1, laquelle contient les en-t\u00eates de colonnes : la barre d’\u00e9tat doit indiquer la valeur Nb (non vide) : 375<\/li>\n\n\n\n
  3. ou allez dans les Pr\u00e9f\u00e9rences d’Excel, cat\u00e9gorie Calcul<\/em> et cochez l’option Utiliser le style de r\u00e9f\u00e9rence L1C1<\/em> : NK affiche alors 375 (n’oubliez pas de d\u00e9sactiver cette option une fois la v\u00e9rification faite) <\/li>\n<\/ol>\n\n\n\n

    <\/p>\n\n\n\n

    <\/p>\n\n\n\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    Contexte Vous avez export\u00e9 les 13’457 enregistrements provenant d’une base de donn\u00e9es FileMaker (ou autres). Vous avez choisi d’exporter les 375 rubriques contenues dans la table. Arriv\u00e9 dans…<\/p>\n","protected":false},"author":83,"featured_media":3806,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[4,72],"tags":[74,23],"class_list":{"0":"post-4970","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"category-office","9":"tag-calcul","10":"tag-outil"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/4970","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/comments?post=4970"}],"version-history":[{"count":4,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/4970\/revisions"}],"predecessor-version":[{"id":4974,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/4970\/revisions\/4974"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3806"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=4970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=4970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=4970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}