1- Step 1 Select your DATA SHEET
2- Step 2 Click on DATA.
3- Step 3 click on REMOVE DUPLICATES.
4- Step 4 Select all columns and click OK.
5- Step 5 A notification will be given and show how many duplicate values have been removed. And how many unique values remain. Click OK.
6- And finally your duplicate value is REMOVED for your datasheet.