Excelbaba

How to remove duplicate value in excel

When you have data and you want to remove duplicate value from excel, it is very easy in excel from “Remove Duplicates”
1.     select Range from spread sheet
2.     Click the Data tab.
3.     Click Remove Duplicates from the Data Tools 


You can select the column from which you want to delete duplicate values 
example: - Select “Name” Check box then the result will shown below.

Excelbaba

About Excelbaba -

Author Description here.. Nulla sagittis convallis. Curabitur consequat. Quisque metus enim, venenatis fermentum, mollis in, porta et, nibh. Duis vulputate elit in elit. Mauris dictum libero id justo.

Subscribe to this Blog via Email :