Saturday, November 10, 2012

Remove Duplicates in Excel

How can you remove duplicates from a list?
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.




 














VoilĂ , the duplicates are gone:



For more advanced ways to handle duplicates (and triplicates, quadruplicates etc.), take a look at my blog Excel is Easy.

No comments:

Post a Comment