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.
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.
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.
PMT() Financial Functions
Calculate the Sum of a Range Using AutoSum function
User Define Function (UDF) In Excel
Macros In Excel
Relative and Absolute Cell Reference in MS Excel
Page Setting and printing In MS Excel
Fill In Excel
How we use The Functions in MS Excel
How we Write Excel Formulas
Components of Excel 2007 Environment
Rounding The Numbers MS Excel
SUMIF FUNCTION In MS EXCEL
COUNTIF Function In MS Excel
COUNTBLANK Function In MS Excel
VLOOKUP Function In MS Excel
Pivot Table In MS Excel
Consolidation In MS Excel
Remove Duplicate Value In MS Excel
Convert Excel Data in to a Table