Excel: How to remove duplicates in Excel

Let’s use the example from the previous lesson

 

Click any cell in the table and select DATA >> Data Tools >> Remove Duplicates.

 

If you select all columns then nothing will happen because each row in out example is unique. But suppose you want just the “Year of birth” to be unique. Then, leave only this position selected. After confirming, all the rows with duplicated years will be removed.