Follow the following steps to remove duplicate rows by using the Excel Advanced Filter. This gives you a data set that contains the first occurrence of a duplicated row but does not contain any further occurrences. The Excel advanced filter has an option that allows you to filter unique records (rows of data) in a spreadsheet and copy the resulting filtered list to a new location. This is possible from the advanced filters. There is also another way to remove any duplicate values in your data from the ribbon. When you press ok, Excel will remove all the duplicate values it finds and give you a summary count of how many values were removed and how many values remain.Įxcel deletes the duplicate rows, as required and display only the remaining unique records in the sheet. Step 5: Once you have ensured that the required fields are checked in the dialogue box, click on the ok button. There are also handy Select All and Unselect All buttons above you can use if you’ve got a long list of columns in your data.

Then you can select which columns to use to determine duplicates.This dialogue box allows you to select which columns of your data set you want to be included in the comparison for duplicate information.If this is checked, then the first row of data will be excluded when finding and removing duplicate values. You need to tell Excel if the data contains column headers in the first row.Step 4: Excel will then select the entire set of data and open up the Remove Duplicates window. Step 3: And click on the Remove Duplicates command button. Step 1: Select a cell inside the data from which you want to remove duplicates data. Follow the following steps to remove duplicate rows by using this command. When you use the Remove Duplicates feature, it will permanently delete the duplicate data.īefore you delete the duplicates, it’s good to copy the original data to another worksheet, so you don’t accidentally lose any information. There is a dedicated command to do it in the ribbon. Removing duplicate value in data is a very common task. Remove Duplicate Rows using Remove Duplicate Command In the box next to values with, pick the formatting you want to apply to the duplicate values. Step 4: Then, a Duplicate Values box appears. How to Delete Duplicate Rows in Excel 665×555 39.8 KB

Find and merge duplicate rows in excel