{"id":9040,"date":"2011-04-19T21:27:26","date_gmt":"2011-04-19T20:27:26","guid":{"rendered":"http:\/\/best-of-high-tech.com\/fr\/?p=9040"},"modified":"2011-04-19T21:27:26","modified_gmt":"2011-04-19T20:27:26","slug":"supprimer-doublon-excel","status":"publish","type":"post","link":"https:\/\/best-of-high-tech.com\/fr\/supprimer-doublon-excel\/","title":{"rendered":"comment rechercher et supprimer les doublons dans excel &#8211; eliminer doublons excel"},"content":{"rendered":"<p style=\"text-align: justify; \">\n\tPour rechercher et supprimer vos doublons sur Excel c&rsquo;est assez simple, par exemple de mails dans une colonne,<\/p>\n<ul>\n<li style=\"text-align: justify; \">\n\t\t1) copiez la colonne sur une feuille vierge<\/li>\n<li style=\"text-align: justify; \">\n\t\t2) s&eacute;lectionnez la colonne o&ugrave; sont vos doublons<\/li>\n<li style=\"text-align: justify; \">\n\t\t3) Selectionnez le Menu &ldquo;Donn&eacute;es&rdquo; puis le sous-menu &ldquo;Filtre&rdquo; puis &ldquo;Filtre &eacute;labor&eacute;&rdquo;<\/li>\n<li style=\"text-align: justify; \">\n\t\t4) cochez &laquo;&nbsp;faire&nbsp; une extraction sans doublon&nbsp;&raquo; et dans&nbsp; &ldquo;espace d&rsquo;origine&rdquo;&nbsp; il y a votre colonne, s&eacute;lectionnez un espace de destination une colonne au moins aussi grande<\/li>\n<li style=\"text-align: justify; \">\n\t\t5) ex&eacute;cutez, Excel garde votre premi&egrave;re colonne et copie toutes vos donn&eacute;es dans le nouvel espace et voila c&#39;est magique tous les doublons ont &eacute;t&eacute; &eacute;limin&eacute;.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Pour rechercher et supprimer vos doublons sur Excel c\u2019est assez simple, voici le tuto.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[77],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/posts\/9040"}],"collection":[{"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/comments?post=9040"}],"version-history":[{"count":6,"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/posts\/9040\/revisions"}],"predecessor-version":[{"id":9046,"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/posts\/9040\/revisions\/9046"}],"wp:attachment":[{"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/media?parent=9040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/categories?post=9040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/tags?post=9040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}