{"id":1931,"date":"2016-06-16T13:11:53","date_gmt":"2016-06-16T11:11:53","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=1931"},"modified":"2022-08-10T15:32:57","modified_gmt":"2022-08-10T13:32:57","slug":"excel-extraire-des-valeurs-uniques-dune-colonne","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2016\/06\/excel-extraire-des-valeurs-uniques-dune-colonne\/","title":{"rendered":"Excel &#8211; Extraire des valeurs uniques d&rsquo;une colonne"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Vous disposez d&rsquo;une colonne contenant par exemple les \u00e2ges des collaborateurs (les \u00e2ges peuvent avoir \u00e9t\u00e9 saisis manuellement ou \u00eatre le fruit d&rsquo;un calcul). Vous aimeriez pouvoir extraire les \u00e2ges de ces personnes mais sous forme de valeurs uniques (certains d&rsquo;entre eux ont bien entendu le m\u00eame \u00e2ge). Vous pensez utiliser une formule de calcul pour faire cela mais vous ne savez pas laquelle ferait l&rsquo;affaire.<\/p>\n<h4><strong>Solution : <\/strong>Laissez tomber l&rsquo;id\u00e9e de la formule de calcul et faites un filtrage avanc\u00e9&#8230;<\/h4>\n<ul>\n<li>Positionnez-vous sur la cellule contenant l&rsquo;en-t\u00eate de la colonne \u00c2ge<\/li>\n<li>Allez dans l&rsquo;onglet Donn\u00e9es &gt; cliquez sur Options avanc\u00e9es de filtre<\/li>\n<li>Indiquez que vous souhaitez extraire et copier les donn\u00e9es \u00e0 un autre emplacement<\/li>\n<li>V\u00e9rifiez que la plage de cellules \u00e0 filtrer est correcte<\/li>\n<li>Choisissez la cellule dans laquelle vous souhaitez effectuer la copie<\/li>\n<li>Cochez l&rsquo;option Extraction sans doublon et validez<\/li>\n<li>Terminez \u00e9ventuellement en faisant un tri Du plus petit au plus grand<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1935 size-full\" src=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2016\/06\/filtre-avance.png\" alt=\"filtre avance\" width=\"600\" height=\"268\" srcset=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2016\/06\/filtre-avance.png 600w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2016\/06\/filtre-avance-300x134.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous disposez d&rsquo;une colonne contenant par exemple les \u00e2ges des collaborateurs (les \u00e2ges peuvent avoir \u00e9t\u00e9 saisis manuellement ou \u00eatre le fruit d&rsquo;un calcul). Vous aimeriez pouvoir&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3582,"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],"tags":[23],"class_list":{"0":"post-1931","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-outil"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/1931","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=1931"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/1931\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3582"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=1931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=1931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=1931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}