There are a few ways to remove duplicates in Excel. One way is to use the Remove Duplicates function under the Data tab. To do this, select the column or range of cells that you want to remove the duplicates from, and then click Remove Duplicates. Excel will remove all of the duplicates and leave the unique values.
Another way to remove duplicates is to use the Filter function. To do this, select the column or range of cells that you want to remove the duplicates from, and then click the Filter button. Excel will open the Filter dialog box. In the dialog box, select the Duplicates check box, and then click OK. Excel will remove all of the duplicates and leave the unique values.