{"id":52,"date":"2020-03-10T22:03:04","date_gmt":"2020-03-10T21:03:04","guid":{"rendered":"http:\/\/excel4ever.fr\/?p=52"},"modified":"2020-03-12T00:39:55","modified_gmt":"2020-03-11T23:39:55","slug":"suppression-des-doublons","status":"publish","type":"post","link":"https:\/\/excel4ever.fr\/index.php\/2020\/03\/10\/suppression-des-doublons\/","title":{"rendered":"Suppression des doublons"},"content":{"rendered":"\n<p>Il existe une fonction tr\u00e8s utile qui permet de supprimer les doublons dans une plage de cellules, pour ne garder que les valeurs uniques.<\/p>\n\n\n\n<p>Soit la liste suivante, on voit que la m\u00eame ville appara\u00eet plusieurs fois.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"235\" height=\"619\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-01-1.png\" alt=\"\" class=\"wp-image-158\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-01-1.png 235w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-01-1-114x300.png 114w\" sizes=\"auto, (max-width: 235px) 100vw, 235px\" \/><\/figure><\/div>\n\n\n\n<p>On s\u00e9lectionne la colonne \u00e0 \u00e9purer, on clique sur le menu \u00ab\u00a0Donn\u00e9es\u00a0\u00bb pour afficher les options de traitement des donn\u00e9es, puis on clique sur le bouton \u00ab\u00a0<strong>Supprimer les doublons<\/strong>\u00a0\u00bb :<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"133\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-02-1024x133.png\" alt=\"\" class=\"wp-image-152\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-02-1024x133.png 1024w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-02-300x39.png 300w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-02-768x99.png 768w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-02.png 1058w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>Excel ouvre une fen\u00eatre r\u00e9capitulative avant de supprimer les doublons.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"504\" height=\"280\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-03.png\" alt=\"\" class=\"wp-image-155\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-03.png 504w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-03-300x167.png 300w\" sizes=\"auto, (max-width: 504px) 100vw, 504px\" \/><\/figure><\/div>\n\n\n\n<p>On voit la colonne qui va \u00eatre trait\u00e9e. On voit \u00e9galement l&rsquo;option \u00ab\u00a0Mes donn\u00e9es ont des en-t\u00eates\u00a0\u00bb qui permet d&rsquo;\u00e9carter automatiquement la premi\u00e8re ligne, dans le cas o\u00f9 le tableau aurait un titre.<\/p>\n\n\n\n<p>Dans notre cas, si l&rsquo;option est coch\u00e9e, la ligne <img loading=\"lazy\" decoding=\"async\" width=\"111\" height=\"36\" class=\"wp-image-160\" style=\"width: 111px;\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-04.png\" alt=\"\"> ne sera jamais supprim\u00e9e, m\u00eame s&rsquo;il existe une ville qui s&rsquo;appelle VILLE dans la liste !<\/p>\n\n\n\n<p>Une fois la suppression lanc\u00e9e, Excel traite la liste et affiche un message informatif, avec le nombre de doublons supprim\u00e9s, et le nombre de valeurs uniques restantes.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"724\" height=\"279\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-05.png\" alt=\"\" class=\"wp-image-161\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-05.png 724w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-05-300x116.png 300w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Pour aller plus loin&#8230;<\/h2>\n\n\n\n<p>On peut appliquer la suppression sur une multitude de colonnes. Si on reprend l&rsquo;exemple, j&rsquo;ai ajout\u00e9 une couleur \u00e0 la ville, et je voudrais ne garder que les associations uniques :<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>New-York \/ Rouge<\/li><li>New-York \/ Orange <\/li><li>New-York \/ Gris <\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"243\" height=\"582\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-06.png\" alt=\"\" class=\"wp-image-163\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-06.png 243w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-06-125x300.png 125w\" sizes=\"auto, (max-width: 243px) 100vw, 243px\" \/><\/figure><\/div>\n\n\n\n<p>On s\u00e9lectionne les deux colonnes, on lance la suppression :<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"503\" height=\"282\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-07.png\" alt=\"\" class=\"wp-image-164\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-07.png 503w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-07-300x168.png 300w\" sizes=\"auto, (max-width: 503px) 100vw, 503px\" \/><\/figure><\/div>\n\n\n\n<p>Excel a bien pris en compte les deux colonnes <strong>VILLE\/Couleur<\/strong> pour faire la suppression. En r\u00e9sultat, il reste les 3 associations uniques, et la ligne de titre.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"737\" height=\"201\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-08.png\" alt=\"\" class=\"wp-image-165\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-08.png 737w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0005-08-300x82.png 300w\" sizes=\"auto, (max-width: 737px) 100vw, 737px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Il existe une fonction tr\u00e8s utile qui permet de supprimer les doublons dans une plage de cellules, pour ne garder que les valeurs uniques. Soit la liste suivante, on voit que la m\u00eame ville appara\u00eet plusieurs fois. On s\u00e9lectionne la colonne \u00e0 \u00e9purer, on clique sur le menu \u00ab\u00a0Donn\u00e9es\u00a0\u00bb pour afficher les options de traitement [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-52","post","type-post","status-publish","format-standard","hentry","category-les-fonctionnalites"],"_links":{"self":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/52","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/comments?post=52"}],"version-history":[{"count":15,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/52\/revisions"}],"predecessor-version":[{"id":192,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/52\/revisions\/192"}],"wp:attachment":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/media?parent=52"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/categories?post=52"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/tags?post=52"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}