Remove Duplicate Rows in Excel
- Select any cell of column A.
- Choose Data ➪ Data Tools ➪ Remove Duplicates.
- The Remove Duplicates dialog box will open.
Remove Duplicates dialog box. Column A is automatically selected.
Note: If your data is in a table, you can also use Table Tools ➪ Design ➪ Tools ➪ Remove Duplicates commands to remove duplicate rows.
The Remove Duplicates dialog box lists all the columns in your data range or table.
- Put check marks on the columns that you want to add in the duplicate search.
- Click OK.
Excel will clean-out the duplicate rows, and a message will be displayed on how many duplicate rows have been removed.
Click OK.
If you want to undo your actions, click the Undo Button in the Quick Access toolbar or press CTRL + Z.
When duplicate rows are found, the first row is kept and subsequent duplicate rows are deleted.
Note: Excel treats values as duplicates on the basis of what cells are displaying, not on the basis of what cells are containing. For example, 5/12/2013 and 5 Dec 2013- these two have the same value for Excel. In the following image, you will see that they generate the same value in the formula box. You will get the second date format (5 Dec 2013) if you select “Long Date” from the number format option. In the same way, $500.50 is different from 500.50, though the first one is just the formatted product of 500.50 value. If you want to count both 5/12/2013 and 5 Dec 2013 as duplicate values, format the whole column and find out the duplicate rows.
Long date format used. The cell contains 5/12/2013 but the cell display 5 Dec 2013.
Currency format is used. The cell contains 500.5 but the cell displays £500.50.
Download Working File
Related Articles
- How to Remove Duplicates Based on Criteria in Excel
- How to Remove Duplicates Using VLOOKUP in Excel
- How to Use Formula to Automatically Remove Duplicates in Excel
- How to Remove Duplicate Rows in Excel Based on Two Columns
- Hide Duplicate Rows Based on One Column in Excel
<< Go Back to Remove Duplicates in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
I used to have similar problems too, but after using “DuplicateFilesDeleter” everything was solved. Try this software and you would be glad you did,
there are many ways in which you can sort the randomized files in the hard disk.
Thanks Fina for sharing.
Regards
I used to have similar problems too, but after using
“long path tool” You can use to solve this problem.
Do not worry if you want to remove the blocked files or too long path files from your system, here I suggest a smooth way. Use “Long path tool” software and keep
yourself cool.