Remove Duplicate Row in Excel 2010

In this article I am going to explain about Remove Duplicate row in excel 2010.
  • 3087

Remove Duplicate Row  in Excel 2010

Remove Duplicate row is the properties of Excel to remove duplicate row from the record. Duplicate row is the such types of row that exists in the table more then one time.

To calculate logical formula we have to follow following steps.

Step 1

Open work sheet and select record from where we want to remove duplicate row.

SelectTableExcel2010.jpg

Step 2

In Data tab click on Remove Duplicate.

RemoveDuplicateExcel2010.jpg

Step 3

After its a Remove Duplicate dialog box will be open.

RemoveDialogBoxSelectionExcel2010.jpg

Step 4

In this dialog box we can choose column name to remove duplicate row. Row will be remove on the basis of selected column name and click OK.

RemoveDialogBoxSelectionExcel2010.jpg

Step 5

A message will be display that show how many record has been deleted.

CountDuplicateValueExcel2010.jpg

Step 6

Finally result will be display.

DuplicateResultExcel2010.jpg

Ask Your Question 
 
Got a programming related question? You may want to post your question here
 

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.