{"id":1071,"date":"2020-06-12T00:03:35","date_gmt":"2020-06-11T18:33:35","guid":{"rendered":"https:\/\/www.thewallstreetschool.com\/blog\/?p=1071"},"modified":"2020-06-12T00:03:35","modified_gmt":"2020-06-11T18:33:35","slug":"how-to-remove-duplicates-in-excel","status":"publish","type":"post","link":"https:\/\/www.thewallstreetschool.com\/stg-new\/how-to-remove-duplicates-in-excel\/","title":{"rendered":"How to remove duplicates in Microsoft Excel &#8211; Step by Step Guide"},"content":{"rendered":"\n<p>Often times, while dealing with data we get duplicate values. These duplicate values can lead to double counting in data and hence give wrong results. This makes it important to remove the duplicates to get the desirable results.<\/p>\n\n\n\n<p class=\"has-background\" style=\"background-color: #f7e6b6;\">To remove duplicates, select the Array where you want to remove duplicates and then press <strong>ALT + A + M<\/strong><\/p>\n\n\n\n<p>For further steps, completely read the article till the end.<\/p>\n\n\n\n<p><strong>Basic Rule<\/strong> : Suppose there is an array which has duplicate entries in Rows 1,2, and 5. While removing duplicates, excel will just keep the first instance of the duplicate, that is Row 1.<\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">Removing Rows with completely duplicate entries<\/h2>\n\n\n\n<p>Consider the example below, where Row 2 and 3 are exactly identical i.e. Name, City and Age, all are similar in these two Rows.<\/p>\n\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" class=\"wp-image-1079\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/sse1.png\" alt=\"\" \/><\/figure>\n<\/div>\n\n\n\n<p>If you wish to remove the rows which are completely duplicate i.e. they have the same entries under all columns (Name, City, Age) then you can simply press <strong>ALT + A + M and tick mark all the columns of the dialogue box<\/strong> that appears, as shown below<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"394\" class=\"wp-image-1080\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/sse-2-1024x394.png\" alt=\"\" srcset=\"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/sse-2-1024x394.png 1024w, https:\/\/www.thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/sse-2-300x115.png 300w, https:\/\/www.thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/sse-2-768x295.png 768w, https:\/\/www.thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/sse-2.png 1479w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>After you click OK, the Excel will keep only the Row with first instance of the entry and remove all the other Rows, which are completely duplicate to it, as shown below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" class=\"wp-image-1081\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/sse-3-1024x357.png\" alt=\"\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Removing Rows with duplicate entries under certain columns<\/h2>\n\n\n\n<p>Consider the example below, where <strong>Name<\/strong> and <strong>Age<\/strong> in Row 3 and 5 are identical. However, the City column in these two Rows are different.<\/p>\n\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"329\" height=\"283\" class=\"wp-image-1076\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/ss4.png\" alt=\"\" srcset=\"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/ss4.png 329w, https:\/\/www.thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/ss4-300x258.png 300w\" sizes=\"(max-width: 329px) 100vw, 329px\" \/><\/figure>\n<\/div>\n\n\n\n<p>If you wish to remove the rows in which certain values are duplicate i.e. they have the same entries under specific columns, then you can simply tick mark those columns in the dialogue box which you want to consider for removing such duplicate rows .<\/p>\n\n\n\n<p>In this example, we want to consider only duplicate entries under &#8216;Name&#8217; and &#8216;Age&#8217;, as shown below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"330\" class=\"wp-image-1077\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/ss5-1024x330.png\" alt=\"\" srcset=\"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/ss5-1024x330.png 1024w, https:\/\/www.thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/ss5-300x97.png 300w, https:\/\/www.thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/ss5-768x247.png 768w, https:\/\/www.thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/ss5-1536x494.png 1536w, https:\/\/www.thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/ss5.png 1569w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>After you click OK, the Excel will keep only the Row with first instance of the duplicate entries and remove all the other Rows, as shown below.<\/p>\n\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"422\" height=\"297\" class=\"wp-image-1078\" src=\"https:\/\/thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/ss6.png\" alt=\"\" srcset=\"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/ss6.png 422w, https:\/\/www.thewallstreetschool.com\/stg-new\/wp-content\/uploads\/2020\/06\/ss6-300x211.png 300w\" sizes=\"(max-width: 422px) 100vw, 422px\" \/><\/figure>\n<\/div>\n\n\n\n<p>We hope that you found this article informative.<\/p>\n\n\n\n\n\n<p>&nbsp;<\/p>\n\n\n\n<p>&nbsp;<\/p>\n\n\n\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Often times, while dealing with data we get duplicate values. These duplicate values can lead to double counting in data and hence give wrong results. This makes it important to remove the duplicates to get the desirable results. To remove duplicates, select the Array where you want to remove duplicates and then press ALT + [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":969,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[798],"tags":[],"class_list":["post-1071","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel"],"_links":{"self":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/posts\/1071","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/comments?post=1071"}],"version-history":[{"count":0,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/posts\/1071\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/media\/969"}],"wp:attachment":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/media?parent=1071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/categories?post=1071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/tags?post=1071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}