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 our 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.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.