Select the range of cells in which to delete duplicates.
Click on the Data tab and then on Remove Duplicates under the Data Tools section
Select the relevant columns that contain duplicates and click on OK
All duplicates have now been deleted.
Select the range of cells in which to delete duplicates.
Click on the Data tab and then on Remove Duplicates under the Data Tools section
Select the relevant columns that contain duplicates and click on OK
All duplicates have now been deleted.