One of the most common scenarios of data cleansing is finding duplicates in Excel. Below are the steps:
Select the data range in Excel in which you want to find the duplicate values.
Under Home Tab, select Conditional Formatting->Duplicate Values:
Click OK and observe the highlighted cells with duplicate values.
You can now filter the data based on color to quickly check the duplicate values. Short-cut to filter is select the header of the column or columns and then Alt+D+F+F on keyboard.