How to Remove Duplicate Values in Excel

It often happens that while entering the data in Microsoft Excel, sometimes the same data is entered twice or thrice, but it is very difficult to find it in a big data because if it is to be found one by one. So it will take too much time.

But there is a In-built features have been given in Microsoft Excel, so that you can easily search for duplicate data, highlight it and you can also delete that duplicate data very easily.If you want to find and delete duplicate data in MS Excel, then you do not need to worry, in this article you have been given complete information in detail below.

1. First of all select the data from which you want to remove the duplicate data.
2. Chose the conditional formatting option in style block
3. click on Highlight cell rules then Duplicates Values
4. After this duplicate word will appear highlights in a different color.

How to delete duplicate value in Excel

As above, we have highlighted all the duplicate data in a different color, only then you can delete the duplicate data, for that you have to follow these steps given below, after which you can easily duplicate all the data. You will be able to delete it.

1. Go to Remove Duplicate option under Data tab.
2. After that a dialog box of Remove Duplicates will open, click on OK
3. Now you can delete the duplicate data easily with sort color option.