{"id":164585,"date":"2022-06-01T09:36:00","date_gmt":"2022-06-01T08:36:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=164118"},"modified":"2024-02-13T16:37:03","modified_gmt":"2024-02-13T16:37:03","slug":"supprimer-doublons-excel","status":"publish","type":"post","link":"https:\/\/datascientest.com\/supprimer-doublons-excel","title":{"rendered":"Comment supprimer les doublons sur Excel ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"164585\" class=\"elementor elementor-164585\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4c7d166 e-flex e-con-boxed e-con\" data-id=\"4c7d166\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0ef2c53 elementor-widget elementor-widget-heading\" data-id=\"0ef2c53\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Se retrouver avec des donn\u00e9es dupliqu\u00e9es sur Excel peut parfois s\u2019av\u00e9rer emb\u00eatant et m\u00eame amener \u00e0 des erreurs et \u00e0 fausser les analyses. Mais pas de panique, trouver et supprimer ces doublons sur Excel est plut\u00f4t chose ais\u00e9e.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-cba1410 e-flex e-con-boxed e-con\" data-id=\"cba1410\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-255618f elementor-widget elementor-widget-heading\" data-id=\"255618f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Tout d\u2019abord, qu\u2019est ce qu\u2019une donn\u00e9e dupliqu\u00e9e ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3238e25 elementor-widget elementor-widget-text-editor\" data-id=\"3238e25\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Les doublons peuvent \u00eatre d\u00e9finis de diff\u00e9rentes mani\u00e8res pour <a href=\"https:\/\/datascientest.com\/base-de-donnees-definition\">une collection de donn\u00e9es<\/a>.<\/p><p>Une simple collection de donn\u00e9es comportant trois colonnes pour la marque, le mod\u00e8le et l&rsquo;ann\u00e9e d&rsquo;une liste de chaussures est pr\u00e9sent\u00e9e ci-dessous.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8b749ee elementor-widget elementor-widget-image\" data-id=\"8b749ee\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/06\/Image1.png\" title=\"\" alt=\"Image1\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d1ffa4b elementor-widget elementor-widget-text-editor\" data-id=\"d1ffa4b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>On remarque que sur la premi\u00e8re colonne, il y a <strong>plusieurs doublons<\/strong> de la marque de chaussures.<\/p><p>Sur la deuxi\u00e8me colonne, on remarque \u00e9galement qu\u2019il y a <strong>des mod\u00e8les qui se r\u00e9p\u00e8tent<\/strong>.\u00a0<\/p><p>Enfin sur la derni\u00e8re colonne, on retrouve plusieurs fois la m\u00eame ann\u00e9e de parution.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b8a0fe0 elementor-widget elementor-widget-image\" data-id=\"b8a0fe0\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/06\/Image2.png\" title=\"\" alt=\"Image2\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-57a1154 elementor-widget elementor-widget-text-editor\" data-id=\"57a1154\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>La deuxi\u00e8me image montre <strong>tous les doublons sur l&rsquo;ensemble des colonnes<\/strong> du tableau. Elle repr\u00e9sente les lignes qui se r\u00e9p\u00e8tent dans le tableau (m\u00eame marque, m\u00eame mod\u00e8le et m\u00eame ann\u00e9e de parution).<\/p><p>G\u00e9rer les doublons bas\u00e9s sur une seule colonne et g\u00e9rer les lignes identiques sur <a href=\"https:\/\/www.microsoft.com\/fr-fr\/microsoft-365\/excel\">Excel<\/a> sont deux manipulations diff\u00e9rentes. Avant de supprimer quelque donn\u00e9e que ce soit, faites attention au <strong>type de doublons<\/strong> que vous souhaitez supprimer.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-28923c6 e-flex e-con-boxed e-con\" data-id=\"28923c6\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4a5e128 elementor-widget elementor-widget-heading\" data-id=\"4a5e128\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment supprimer les doublons sur Excel ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-53c580b elementor-widget elementor-widget-text-editor\" data-id=\"53c580b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Avec la commande <strong>Supprimer<\/strong> les doublons sur Excel, vous pouvez trouver et supprimer les valeurs en double.<\/p><p>La suppression des valeurs en double dans les donn\u00e9es est une activit\u00e9 r\u00e9guli\u00e8re. Elle est si fr\u00e9quente que le ruban Excel dispose d&rsquo;<strong>une commande sp\u00e9ciale<\/strong> \u00e0 cet effet.<\/p><p>Attention, cette commande supprime les lignes en double et non les doublons qui se trouvent sur une m\u00eame colonne.\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-46fb6c2 elementor-widget elementor-widget-image\" data-id=\"46fb6c2\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/06\/Image3-1.png\" title=\"\" alt=\"Image3\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2546a58 elementor-widget elementor-widget-text-editor\" data-id=\"2546a58\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Allez dans l&rsquo;onglet <strong>Donn\u00e9es<\/strong> et cliquez sur la commande <strong>Supprimer <\/strong>les doublons dans une cellule des donn\u00e9es dont vous souhaitez supprimer les doublons.<\/p><p>La fen\u00eatre Supprimer les doublons appara\u00eet apr\u00e8s qu&rsquo;Excel ait s\u00e9lectionn\u00e9 l&rsquo;ensemble des donn\u00e9es.<\/p><p>Vous devez ensuite indiquer \u00e0 Excel si la premi\u00e8re ligne de donn\u00e9es contient des en-t\u00eates de colonne. Si cette option est s\u00e9lectionn\u00e9e, <strong>la premi\u00e8re ligne de donn\u00e9es<\/strong> sera ignor\u00e9e lors de la recherche et de l&rsquo;\u00e9limination des valeurs en double.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-16b785b elementor-widget elementor-widget-image\" data-id=\"16b785b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/06\/Image4.png\" title=\"\" alt=\"Image4\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7bd0cfb elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"7bd0cfb\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-power-bi\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Se former en analyse de donn\u00e9es<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-35fbea8 elementor-widget elementor-widget-text-editor\" data-id=\"35fbea8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Vous pouvez ensuite choisir les colonnes \u00e0 utiliser pour <strong>trouver les doublons<\/strong>. Si vos donn\u00e9es contiennent une longue liste de colonnes, vous pouvez utiliser les boutons S\u00e9lectionner tout et D\u00e9s\u00e9lectionner tout ci-dessus.<\/p><p>Lorsque vous appuyez sur <strong>OK<\/strong>, Excel supprime toutes les valeurs en double qu&rsquo;il d\u00e9couvre et vous fournit un compte r\u00e9capitulatif du nombre de valeurs supprim\u00e9es et du nombre de valeurs restantes.<\/p><p><strong>Astuce <\/strong>: Comme ce programme modifie vos donn\u00e9es, il est recommand\u00e9 de l&rsquo;ex\u00e9cuter sur une copie de vos donn\u00e9es afin de conserver les donn\u00e9es originales intactes.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f9b4763 elementor-widget elementor-widget-heading\" data-id=\"f9b4763\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Supprimer les doublons \u00e0 l\u2019aide d\u2019un tableau crois\u00e9 dynamique : <\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6d93cb2 elementor-widget elementor-widget-text-editor\" data-id=\"6d93cb2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Avec un tableau crois\u00e9 dynamique, vous pouvez <strong>trouver et supprimer les valeurs en double<\/strong>.<\/p><p>Les tableaux crois\u00e9s dynamiques ne servent pas uniquement \u00e0 examiner vos donn\u00e9es. Vous pouvez \u00e9galement les utiliser pour vous d\u00e9barrasser de vos <strong>donn\u00e9es en double<\/strong> !<\/p><p>Cependant cette m\u00e9thode n\u2019est pas directe. Elle ne supprime pas vraiment les valeurs en double de vos donn\u00e9es ; elle utilise plut\u00f4t la fonction du tableau crois\u00e9 dynamique qui affiche<strong> les valeurs de l\u2019ensemble de vos donn\u00e9es en un unique exemplaire<\/strong>.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3cebc16 elementor-widget elementor-widget-heading\" data-id=\"3cebc16\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\"><i>Comment \u00e7a marche ?<\/i><\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6ac95a3 elementor-widget elementor-widget-text-editor\" data-id=\"6ac95a3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p style=\"padding-left: 40px;\">Cr\u00e9ez d&rsquo;abord un tableau crois\u00e9 dynamique \u00e0 partir de vos donn\u00e9es. S\u00e9lectionnez une cellule ou la plage compl\u00e8te de donn\u00e9es dans vos donn\u00e9es, puis allez dans l&rsquo;onglet <b>Insertion<\/b>, s\u00e9lectionnez <b>Tableau crois\u00e9 dynamique<\/b> et cliquez sur <b>OK<\/b> dans la bo\u00eete de dialogue Cr\u00e9er un tableau crois\u00e9 dynamique.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d4b0a66 elementor-widget elementor-widget-image\" data-id=\"d4b0a66\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/06\/Image5-1.png\" title=\"\" alt=\"Image5\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-70f4f6a elementor-widget elementor-widget-text-editor\" data-id=\"70f4f6a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p style=\"padding-left: 40px;\">Ajoutez tous les champs \u00e0 la zone <strong>\u00ab\u00a0Lignes\u00a0\u00bb<\/strong> du tableau crois\u00e9 dynamique.<\/p><p style=\"padding-left: 40px;\">La mise en page du tableau crois\u00e9 dynamique r\u00e9sultant doit ensuite \u00eatre modifi\u00e9e en un format tabulaire. S\u00e9lectionnez <b>Mise en page du rapport<\/b> dans l&rsquo;onglet <b>Conception<\/b> alors que le tableau crois\u00e9 dynamique est s\u00e9lectionn\u00e9. Vous devrez mettre \u00e0 jour deux options dans cette section.<\/p><ul><li style=\"list-style-type: none;\"><ul><li>Choisissez <strong>Afficher <\/strong>sous forme tabulaire dans le menu d\u00e9roulant.<\/li><\/ul><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5ea39c6 elementor-widget elementor-widget-image\" data-id=\"5ea39c6\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/06\/Image6-1.png\" title=\"\" alt=\"Image6\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-803fbd5 elementor-widget elementor-widget-text-editor\" data-id=\"803fbd5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li style=\"list-style-type: none;\"><ul><li>S\u00e9lectionnez l&rsquo;option permettant de <strong>r\u00e9p\u00e9ter toutes les \u00e9tiquettes des \u00e9l\u00e9ments<\/strong>.<\/li><\/ul><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-89961e3 elementor-widget elementor-widget-image\" data-id=\"89961e3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/06\/Image7-1.png\" title=\"\" alt=\"Image7\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1866db9 elementor-widget elementor-widget-text-editor\" data-id=\"1866db9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Vous voudrez \u00e9galement vous d\u00e9barrasser de tous les sous-totaux du tableau crois\u00e9 dynamique. S\u00e9lectionnez <strong>\u00ab\u00a0Sous-totaux\u00a0\u00bb<\/strong> dans l&rsquo;onglet Cr\u00e9ation, puis <strong>\u00ab\u00a0Ne pas afficher les sous-totaux\u00a0\u00bb<\/strong>.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ee3f4b7 elementor-widget elementor-widget-image\" data-id=\"ee3f4b7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/06\/Image9.png\" title=\"\" alt=\"Image9\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-551123a elementor-widget elementor-widget-text-editor\" data-id=\"551123a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Vous avez maintenant un <strong>tableau crois\u00e9 dynamique<\/strong> qui ressemble \u00e0 un tableau de donn\u00e9es !<\/p><p>En effet, les tableaux crois\u00e9s dynamiques ne r\u00e9pertorient que les valeurs uniques des \u00e9l\u00e9ments de la zone \u201cLignes\u201d.<\/p><p>En conclusion, <strong>les valeurs dupliqu\u00e9es dans vos donn\u00e9es <\/strong>peuvent entraver la cr\u00e9ation d&rsquo;un ensemble de donn\u00e9es propre.<\/p><p>Heureusement, Excel offre de nombreuses possibilit\u00e9s pour supprimer ces doublons irritants.<\/p><p>Et vous, quelle m\u00e9thode comptez-vous utiliser pour vous <strong>d\u00e9barrasser des doublons <\/strong>?<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a13d49c elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"a13d49c\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"\/formations-data\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir nos formations en Data<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Se retrouver avec des donn\u00e9es dupliqu\u00e9es sur Excel peut parfois s\u2019av\u00e9rer emb\u00eatant et m\u00eame amener \u00e0 des erreurs et \u00e0 fausser les analyses. Mais pas de panique, trouver et supprimer ces doublons sur Excel est plut\u00f4t chose ais\u00e9e. Tout d\u2019abord, qu\u2019est ce qu\u2019une donn\u00e9e dupliqu\u00e9e ? Les doublons peuvent \u00eatre d\u00e9finis de diff\u00e9rentes mani\u00e8res pour [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":165059,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"tags":[164],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Comment supprimer les doublons sur Excel ?<\/title>\n<meta name=\"description\" content=\"Vous en avez assez des doublons sur vos feuilles de calcul Excel. D\u00e9couvrez comment les supprimer gr\u00e2ce \u00e0 ce tutoriel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/supprimer-doublons-excel\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment supprimer les doublons sur Excel ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/supprimer-doublons-excel\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-01T08:36:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-13T16:37:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/06\/supprimer-doublons-excel.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1520\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/supprimer-doublons-excel\",\"url\":\"https:\/\/datascientest.com\/supprimer-doublons-excel\",\"name\":\"Comment supprimer les doublons sur Excel ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2022-06-01T08:36:00+00:00\",\"dateModified\":\"2024-02-13T16:37:03+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Vous en avez assez des doublons sur vos feuilles de calcul Excel. D\u00e9couvrez comment les supprimer gr\u00e2ce \u00e0 ce tutoriel.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/supprimer-doublons-excel\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Comment supprimer les doublons sur Excel ?","description":"Vous en avez assez des doublons sur vos feuilles de calcul Excel. D\u00e9couvrez comment les supprimer gr\u00e2ce \u00e0 ce tutoriel.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/supprimer-doublons-excel","og_locale":"fr_FR","og_type":"article","og_title":"Comment supprimer les doublons sur Excel ?","og_url":"https:\/\/datascientest.com\/supprimer-doublons-excel","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2022-06-01T08:36:00+00:00","article_modified_time":"2024-02-13T16:37:03+00:00","og_image":[{"width":1520,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/06\/supprimer-doublons-excel.jpeg","type":"image\/jpeg"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/supprimer-doublons-excel","url":"https:\/\/datascientest.com\/supprimer-doublons-excel","name":"Comment supprimer les doublons sur Excel ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2022-06-01T08:36:00+00:00","dateModified":"2024-02-13T16:37:03+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Vous en avez assez des doublons sur vos feuilles de calcul Excel. D\u00e9couvrez comment les supprimer gr\u00e2ce \u00e0 ce tutoriel.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/supprimer-doublons-excel"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/164585"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=164585"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/164585\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/165059"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=164585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=164585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=164585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}