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.