{"id":2248,"date":"2015-03-31T15:10:08","date_gmt":"2015-03-31T15:10:08","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/?p=2248"},"modified":"2023-12-31T00:05:58","modified_gmt":"2023-12-31T00:05:58","slug":"remove-duplicates-in-excel","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/remove-duplicates-in-excel\/","title":{"rendered":"Remove Duplicates in Excel"},"content":{"rendered":"

How to remove duplicates\u00a0from a column of data in Excel<\/strong><\/h2>\n

It’s not uncommon when adding or importing records that you may need to remove duplicates in Excel. Whilst\u00a0filtering and deleting records to make a list of unique items is an effective solution, there is an even easier way.
\nSimply follow these steps to remove duplicates in Excel.<\/p>\n

Step 1<\/strong> Copy the column of data containing the repeated or duplicate items to a blank column.<\/p>\n

Step 2<\/strong> Highlight\u00a0the copied column\u00a0of data and\u00a0select Data,<\/strong> Remove Duplicates<\/strong>.<\/p>\n

\"RemoveDuplicates\"<\/a><\/p>\n

Step 3<\/strong> From dialog box\u00a0remove the tick\u00a0next to\u00a0‘My\u00a0data has headers’ if you did not include\u00a0a header at the top of your data.<\/p>\n

\"RemoveDuplicatesDialog\"<\/a>
Remove Duplicates in Excel<\/figcaption><\/figure>\n

 <\/p>\n

Step 4<\/strong> Press OK<\/strong> and all the duplicates will be removed.<\/p>\n

A message\u00a0displays at the end telling you\u00a0how many duplicates\u00a0have been removed.<\/p>\n

\"RemoveDuplicatesResult2\"<\/a><\/p>\n

\u00a0<\/strong><\/p>\n

Remove duplicates\u00a0in Excel\u00a0for more than<\/strong> one column<\/strong><\/h2>\n

The\u00a0Remove Duplicates in Excel feature also allows duplicates to be found in a combination of columns.<\/p>\n

For example suppose from the data below\u00a0you want to remove\u00a0items\u00a0where the Date and Country are the\u00a0same value.<\/p>\n

\"RemoveDuplidcatesMultiCols2\"<\/a><\/p>\n

This time the data contains headers for clarity.
\nWith both\u00a0columns ticked duplicates are only removed if rows have the same Date and the same Country. The result is:<\/p>\n

\"RemoveDuplicatesMultiColResult\"<\/a><\/p>\n

Note that ticking only the Country column and not ticking the Date column will display as before the first 8 unique countries.<\/p>\n

Additional Resources<\/h3>\n

Using the Advanced Filter in Excel<\/a><\/p>\n

How to highlight duplicates in Excel 2010?<\/a><\/p>\n

How to remove duplicate records<\/a><\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

How to remove duplicates\u00a0from a column of data in Excel It’s not uncommon when adding or importing records that you may need to remove duplicates in Excel. Whilst\u00a0filtering and deleting records to make a list of unique items is an effective solution, there is an even easier way. Simply follow these steps to remove duplicates […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,6],"tags":[456,457,458],"class_list":["post-2248","post","type-post","status-publish","format-standard","hentry","category-excel-training","category-hints-tips","tag-remove-duplicate-columns-in-excel","tag-remove-duplicate-records-in-excel","tag-remove-duplicate-values-in-excel"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=2248"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2248\/revisions"}],"predecessor-version":[{"id":6890,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2248\/revisions\/6890"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=2248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=2248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=2248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}