Remove Duplicate Values in Excel !

In the previous post i told you guys how to highlight duplicate data, now i will be showing you guys how to remove the duplicate values, the easy way.

Select the Column or Columns on which you want to apply the Remove duplicate option.

1. Go to the Data tab in the ribbon
2. Click Remove Duplicates in the Data Tools section.
3. A window will pop-up shown you the columns that have been selected for this operation.
4. Click Ok and there it is, a Dialogue box will appear showing the details of how many duplicate entries were removed.

Keep visiting for more interesting excel options which can make your life a-lot easier.

Comments and suggestion are welcomed.

Best Regards,