{"id":161,"date":"2009-10-18T14:27:00","date_gmt":"2009-10-18T18:27:00","guid":{"rendered":"http:\/\/exceltheatre.com\/blog\/archives\/2009\/10\/18\/remove-duplicates-in-excel-2003\/"},"modified":"2024-11-19T13:56:38","modified_gmt":"2024-11-19T18:56:38","slug":"remove-duplicates-in-excel-2003","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2009\/10\/18\/remove-duplicates-in-excel-2003\/","title":{"rendered":"Remove Duplicates in Excel"},"content":{"rendered":"<p>If I need a list of unique items from a long list, I usually use an Advanced Filter, because it leaves the original list alone, and extracts a list of unique records. But, if you want to remove duplicate items quickly and easily, there&#8217;s a new tool in Excel 2007.<\/p>\n<h3>Excel 2007<\/h3>\n<p>In Excel 2007, if there are duplicate items in a list, you can delete them by using <a href=\"https:\/\/contexturesblog.com\/archives\/2009\/12\/14\/remove-duplicates-in-excel-2007\/\" target=\"_blank\" rel=\"noopener\">the Remove Duplicates tool<\/a>, which is new in this version.<\/p>\n<p>To remove the duplicates, follow the steps in this short Excel video tutorial.<\/p>\n<p><iframe loading=\"lazy\" title=\"Remove Duplicates in Excel 2007\" width=\"840\" height=\"630\" src=\"https:\/\/www.youtube.com\/embed\/BzLgW5DIcz0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3>One or More Columns<\/h3>\n<p>In Excel 2007 or later, if there are duplicate items in a list, you can delete them by using the Remove Duplicates tool. The duplicates can be removed based on entries in a single column, or multiple columns<\/p>\n<p>To remove the duplicates, follow the steps in this short Excel video tutorial.<\/p>\n<p><iframe loading=\"lazy\" title=\"Remove Duplicates From Excel List Multiple or Single Column\" width=\"840\" height=\"630\" src=\"https:\/\/www.youtube.com\/embed\/gJKm32xOUjg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3>Excel 2003<\/h3>\n<p>In Excel 2003, if there are duplicate items in a list, you can delete them by using an Advanced Filter.<\/p>\n<p>To remove the duplicates, follow the steps in this short Excel video tutorial.<\/p>\n<p><iframe loading=\"lazy\" title=\"Remove Duplicate Records in Excel 2003\" width=\"840\" height=\"630\" src=\"https:\/\/www.youtube.com\/embed\/4Or6vvdA6sY?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>______________<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If I need a list of unique items from a long list, I usually use an Advanced Filter, because it leaves the original list alone, and extracts a list of unique records. But, if you want to remove duplicate items quickly and easily, there&#8217;s a new tool in Excel 2007. Excel 2007 In Excel 2007, &hellip; <a href=\"https:\/\/exceltheatre.com\/blog\/archives\/2009\/10\/18\/remove-duplicates-in-excel-2003\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Remove Duplicates in Excel&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-161","post","type-post","status-publish","format-standard","hentry","category-excel-videos"],"_links":{"self":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/161","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/comments?post=161"}],"version-history":[{"count":2,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/161\/revisions"}],"predecessor-version":[{"id":4555,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/161\/revisions\/4555"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}