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

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

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 learn how to remove duplicate value in Excel or remove duplicate in Excel using Remove Duplicate tools in toolbar. There are many more variation to remove duplicate values using conditional formatting and many more.

Recommend

 

FREE MS Office Courses {No Credit Card Required}

Free MS Office Course Online

Related Tutorials

Power Bi Dax Deduplication Based On Column
December 17, 2018
Special Character Symbol List with Shortcodes in Excel
December 15, 2018
How to use AVERAGEIFS FUNCTION in Excel
December 10, 2018
How to use AVERAGEIF FUNCTION
December 10, 2018
How to use ABS Function in Excel
December 10, 2018
How to use AND Function in Excel
December 10, 2018
Excel Formulas PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018
Strikethrough Shortcut in Excel & Word
July 4, 2018
INDIRECT Function with SUM, MAX, MIN & Independent Cell Value
June 29, 2018
Pivot Table Slicers In Excel
June 12, 2018
How to Split Cells in Excel using Text to Column
June 7, 2018
How to Wrap Text in Excel Automatically and Manually
June 6, 2018
How to Hide/Unhide Column in Excel
June 5, 2018
Highlight row based on cell value
June 4, 2018
Learn how to remove blank cells in Excel
June 3, 2018
How to Group Numbers, Dates & Text in Pivot table in Excel
June 1, 2018
5 Powerful Tricks to Format cells in Excel
May 31, 2018
Insert a Picture into a Cell in Excel
May 25, 2018