Remove Duplicates in Excel

How can you remove duplicates from a list in Excel?

Easy! Excel has a built-in feature for this. Just select one of the cells in the list and click on Remove Duplicates on the Data ribbon.

EasyExcel_31_1_Remove Duplicates in Excel

EasyExcel_31_2_Remove Duplicates in Excel

Voilà, the duplicates are gone:

For more advanced ways to handle duplicates (and triplicates, quadruplicates etc.), take a look at this article: How to Find Duplicates and Triplicates in Excel

More Easy Tricks:


Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.

Did you enjoy this article? Get free email updates! Enter your email address here:

Delivered by FeedBurner

Clip to Evernote

Leave a Reply

Your email address will not be published. Required fields are marked *


+ two = 5

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>