Find and Remove Duplicate Value In Excel

You want to remove Duplicate data in your excel sheet. You can Find, highlight the duplicates before removal is better than removing all the duplicates straightway.

Step 1 : Select the range of duplicate values cells that should be removed after it click on data tab.

Step 2 : After selecting Data go Data Tab > Remove Duplicates and then checking the columns which you wish to purge, you can remove duplicate records using this simple way.

 Step 3 : Then click OK.