MS Excel Tutorial

Remove Duplicate Value In MS Excel

Removing duplicate values are are very important task in MS Excel. . A duplicate value is one where all values in the row are an exact match of all the values in another row. After deleting duplicate values you can get unique data in the table or Simple in List.

Excel 2007 and excel 2010 has a powerful data function that allows you to simply select a set of data and remove duplicate rows. The data function approach is probably both the simplest and the fastest way to remove duplicate values in Excel.

  • To use this function, simply select the Data menu tab and select Data Tools group and click the button for Remove Duplicates.

In appearing dialog box select the the column heading which make the row and match with other row. in my case All three Column.

If you select multiple columns to test, Excel will only remove rows that have the exact same values for all selected columns. In this situation, assuming that two values are duplicated in the Unique ID field, as long as one of the other selected fields is different, Excel will not delete that row.

for example in our case Majid appear two time but if we see all three column then paid amount is different with each other so in this case if we select all three column then Majid is not duplicate record.

Checking all the columns is a better approach if you only want to remove rows that are an exact duplicate of another row. You can then use one of the other methods described below to investigate any additional duplicates in the Unique ID field.

visit www.learninghints.com

Learninghints.Com Learninghints.Com Learninghints.Com

After the pressing ok button process is completed and the data function tells you how many duplicates were identified and removed.

If you like This Share with it with Your friends.