If you have a list or table with duplicate values, you can highlight or delete them.
To highlight duplicates, select the table and use Conditional Formatting. Select Highlight Cells Rules –> Duplicate Values.
Select how you want duplicate cells formatted and click OK.
To remove duplicates, highlight a table, go to the Data tab on the ribbon, and select Remove Duplicates.
Select the column that has duplicate values in it and click OK. Excel will leave the first row with that value.
You can also find duplicates based on multiple columns, for example if a list of quarterly sales has a duplicate of a salesperson’s results for one quarter in a particular region.
