fbpx

Delete Duplicate in Excel or Remove Duplicate in Excel

How to Delete Duplicate in Excel or find and remove duplicate?

Find duplicates for one or more fields, such as a Name or City field, with the same data and want to limit the records to unique data for some fields.



When you remove duplicate values, only the values in the range of cells or table are affected. Any other values outside the range of cells or table are not altered or moved. Still, because you are permanently deleting data, it’s a good idea to copy the original range of cells or table to another worksheet or workbook before removing duplicate values.

Recommend

Excel Power Users Ebook

Be Smart at Excel | New Skills for New JOB

This eBook will help you to get Excel Skills & Boost your career

Steps to Delete Duplicate in Excel or find and remove duplicate

  1. Click any single cell inside the data set.

Select the data, Remove duplicate in excel

  1. On the Data tab, click Remove Duplicates.

how to remove duplicate

  1. The following dialog box appears. Click On all checkboxes and click OK.

column-selection-in-remove-duplicate

Note: Duplicate data has been removed from the data set

ARE YOU STRUGGLING WITH EXCEL FORMULAS?
Become a "Hero at Office"• 200+ Video Lessons • Real-life Case studies • Lifetime Access

 

Image-4-Effect-of-remove-duplicate

To remove rows with the same values in certain columns in excel, execute the following steps:

  1. For example, remove rows with the same Airport Name. Select any single cell inside the data set.

Image-5-Remove-Duplicate

  1. Check Airport Name and click OK.

Image-6-Remove-Duplicate

Conclusion: You must have learned how to remove the duplicate value in Excel or remove duplicate in Excel Online using Remove Duplicate tools in the toolbar. There are many more variables to remove duplicate values using conditional formatting and many more.



Recommend