1.0Brenda Penmanhttps://www.brendapenman.com/blogBrenda Penmanhttps://www.brendapenman.com/blog/author/mfvwwyzbgoqzie/rich600338<blockquote class="wp-embedded-content" data-secret="znrQUQmDIP"><a href="https://www.brendapenman.com/blog/remove-duplicates-in-excel/">Remove Duplicates in Excel to Clean Up Your Data</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.brendapenman.com/blog/remove-duplicates-in-excel/embed/#?secret=znrQUQmDIP" width="600" height="338" title="“Remove Duplicates in Excel to Clean Up Your Data” — Brenda Penman" data-secret="znrQUQmDIP" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script> /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); //# sourceURL=https://www.brendapenman.com/wp-includes/js/wp-embed.min.js </script> https://www.brendapenman.com/wp-content/uploads/2018/02/RemoveDuplicates0.png1080716If you compile data from multiple sources into a single worksheet, you may end up with duplicate rows. Instead of manually looking through your data and deleting duplicate rows, use the Remove Duplicates feature to get Excel to delete the duplicate rows for you. Discover how to use Excel's Remove Duplicates command [...]