There are several different methods to handle the duplicates, but using Excel's built-in tool is the easiest. Select the range containing duplicates. Click on the Data tab. Then, click Remove ...

How to remove duplicates in Excel for a single column When you have duplicate data that you want to remove from a single column in your dataset, start by clicking into the column you want to dedupe.