{"id":687,"date":"2010-07-10T23:53:37","date_gmt":"2010-07-10T21:53:37","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=687"},"modified":"2024-04-18T09:56:53","modified_gmt":"2024-04-18T07:56:53","slug":"odstraneni-duplicit-v-excel-2007","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/odstraneni-duplicit-v-excel-2007\/","title":{"rendered":"Remove duplicates in Excel"},"content":{"rendered":"<p><\/p>\n<p style=\"text-align: justify;\">Are you\u00a0trying to gain unique values from a large or small list of repeating records? Elimination of duplicates is common\u00a0question\u00a0on\u00a0training, so I put here how to do it in Excel 2007 and\u00a0newer. Earlier this\u00a0was\u00a0possible only by using advanced filter, which allowed the filtering records without duplicates. In Excel 2007 version it easier for us by the Data tab where we find the button that will do it much faster.<\/p>\n<p style=\"text-align: justify;\">Firstly, let us make a sample with which you can encounter: We have a list of all our clients and they are obviously from different countries. We are interested in the list of countries from which we have clients, but we want only unique values. Each\u00a0country we want to write in the list only once, and not a hundred times for a hundred clients.<\/p>\n<figure id=\"attachment_688\" aria-describedby=\"caption-attachment-688\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2010\/07\/odebrani_duplicit.gif\"><img decoding=\"async\" class=\"size-medium wp-image-688 \" style=\"border: 0pt none;\" title=\"Odebr\u00e1n\u00ed duplicit excel 2007\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2010\/07\/odebrani_duplicit-300x180.gif\" alt=\"Odebr\u00e1n\u00ed duplicit excel 2007\" width=\"300\" height=\"180\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2010\/07\/odebrani_duplicit-300x180.gif 300w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2010\/07\/odebrani_duplicit.gif 735w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-688\" class=\"wp-caption-text\">Remove duplicates<\/figcaption><\/figure>\n<p>To remove duplicates in Excel use the Data tab and click Remove duplicates. The exact procedure is as follows:<\/p>\n<ol>\n<li>Copy the list of repeating values including a header (column name) into an empty area<\/li>\n<li>Select the copied range and activate the Remove\u00a0duplicates\u00a0button on the Data tab<\/li>\n<li>Make sure that Excel selects\u00a0the correct\u00a0column, and whether it is checked that the data includes header<\/li>\n<li>Removing duplicates is done \ud83d\ude42<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">If this guide has helped you, become a fan on <a href=\"http:\/\/www.facebook.com\/itlektorcz\" target=\"_blank\" rel=\"noopener\">Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n<p><\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Are you\u00a0trying to gain unique values from a large or small list of repeating records? Elimination of duplicates is common\u00a0question\u00a0on\u00a0training, so I put here how to do it in Excel 2007 and\u00a0newer. Earlier this\u00a0was\u00a0possible only by using advanced filter, which allowed the filtering records without duplicates. In Excel 2007 version it easier for us by [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3],"tags":[10,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/687"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=687"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/687\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}