Remove duplicates from a list

Select the cell range where you want to remove the duplicates.

On the Data tab under Data Tools, select   Remove Duplicates.

Include all the columns with duplicates and select OK.

Select the cell range where you want to remove the duplicates.

On the Data tab under Data Tools, select   Remove Duplicates.

Include all the columns with duplicates and select OK.