{"id":10684,"date":"2022-12-04T20:07:11","date_gmt":"2022-12-04T19:07:11","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10684"},"modified":"2022-12-04T20:07:11","modified_gmt":"2022-12-04T19:07:11","slug":"excel-supprimer-les-doublons","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10684","title":{"rendered":"Excel : supprimer les doublons"},"content":{"rendered":"<p style=\"text-align: justify;\"><strong>Supprimer les doublons<\/strong> d&#8217;une liste est une t\u00e2che fr\u00e9quente dans le cadre du <strong>nettoyage de donn\u00e9es<\/strong>. Excel propose une une solution ais\u00e9e \u00e0 utiliser.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10685\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Suppression-doublons-1.png\" alt=\"Suppression doublons 1\" width=\"560\" height=\"512\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Suppression-doublons-1.png 560w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Suppression-doublons-1-300x274.png 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/p>\n<p>Mode op\u00e9ratoire :<\/p>\n<ul>\n<li style=\"text-align: justify;\">S\u00e9lectionner la <strong>plage de cellules<\/strong> \u00e0 traiter<\/li>\n<li style=\"text-align: justify;\">Se rendre dans le <strong>Menu Donn\u00e9es \/ Supprimer les doublons<\/strong><\/li>\n<li style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10688\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Suppression-doublons-BOUTON.png\" alt=\"Suppression doublons BOUTON\" width=\"240\" height=\"43\">Confirmer les <strong>colonnes \u00e0 prendre en compte<\/strong> :<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10687\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Suppression-doublons-3.png\" alt=\"Suppression doublons 3\" width=\"512\" height=\"285\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Suppression-doublons-3.png 512w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Suppression-doublons-3-300x167.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/>C&#8217;est l&#8217;association de l&#8217;ensemble des colonnes s\u00e9lectionn\u00e9es qui d\u00e9termine la pr\u00e9sence (ou non) de doublons.<\/p>\n<p style=\"text-align: justify;\">Exemple 1 : s\u00e9lection des 3 colonnes (aucun doublon)<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10686\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Suppression-doublons-2.png\" alt=\"Suppression doublons 2\" width=\"425\" height=\"490\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Suppression-doublons-2.png 425w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Suppression-doublons-2-260x300.png 260w\" sizes=\"auto, (max-width: 425px) 100vw, 425px\" \/><br \/>\nExemple 2 : s\u00e9lection des colonnes A et B (9 doublons d\u00e9tect\u00e9s)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10685\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Suppression-doublons-1.png\" alt=\"Suppression doublons 1\" width=\"560\" height=\"512\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Suppression-doublons-1.png 560w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Suppression-doublons-1-300x274.png 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/p>\n<p style=\"text-align: justify;\">Autres articles en rapport avec la d\u00e9tection et la suppression des doublons :<\/p>\n<ul>\n<li><a href=\"https:\/\/www.auditsi.eu\/?p=8383\">EXCEL : mettre en \u00e9vidence les doublons avec les formats conditionnels<\/a><\/li>\n<li><a href=\"https:\/\/www.auditsi.eu\/?p=6915\">Les requ\u00eates SQL UNION<\/a><\/li>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/?p=8313\">SQL : d\u00e9tecter les achats comptabilis\u00e9s en double<\/a><\/li>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/?p=710\">EXCEL, VBA : Supprimer les doublons d\u2019une liste<\/a><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet :&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?cat=2765\">Formation Analyse de donn\u00e9es et automatisation avec Excel et Access (gratuite)<\/a>&nbsp;\/&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?glossary=excel\">Tout savoir sur Excel<\/a>&nbsp;\/&nbsp;<a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"https:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a><\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Excel%20%3A%20supprimer%20les%20doublons\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Supprimer les doublons d&#8217;une liste est une t\u00e2che fr\u00e9quente dans le cadre du nettoyage de donn\u00e9es. Excel propose une une solution ais\u00e9e \u00e0 utiliser. Mode op\u00e9ratoire : S\u00e9lectionner la plage de cellules \u00e0 traiter Se rendre dans le Menu Donn\u00e9es \/ Supprimer les doublons Confirmer les colonnes \u00e0 prendre en compte : C&#8217;est l&#8217;association de &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10684\" class=\"more-link\">Continue reading &lsquo;Excel : supprimer les doublons&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Excel%20%3A%20supprimer%20les%20doublons\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1326],"tags":[166,1633,2339,438],"class_list":["post-10684","post","type-post","status-publish","format-standard","hentry","category-maitriser-excel","tag-analyse-de-donnees","tag-excel","tag-nettoyage-des-donnees","tag-supprimer-les-doublons"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10684"}],"version-history":[{"count":3,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10684\/revisions"}],"predecessor-version":[{"id":10691,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10684\/revisions\/10691"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}