You may have to highlight duplicate entries in the excel and you may think it is very difficult to do. We have a solution for it. You need to just copy the below code and it to the excel.
In order to add the code to excel, please follow the steps given below:
1. Open the Excel file.
2. Right click on the page name.
3. Click on the 'View code' option.
4. Paste the following code and save.
5. Sort the column using 'Sort' option.
6. Go to the macros and click on the 'Run' button.In order to add the code to excel, please follow the steps given below:
1. Open the Excel file.
2. Right click on the page name.
3. Click on the 'View code' option.
4. Paste the following code and save.
Sub FindDups ()
'
' NOTE: You must select the first cell in the column and
' make sure that the column is sorted before running this macro
'
ScreenUpdating = False
FirstItem = ActiveCell.Value
SecondItem = ActiveCell.Offset(1, 0).Value
Offsetcount = 1
Do While ActiveCell <> ""
If FirstItem = SecondItem Then
ActiveCell.Offset(Offsetcount,0).Interior.Color = RGB(255,0,0)
Offsetcount = Offsetcount + 1
SecondItem = ActiveCell.Offset(Offsetcount, 0).Value
Else
ActiveCell.Offset(Offsetcount, 0).Select
FirstItem = ActiveCell.Value
SecondItem = ActiveCell.Offset(1,0).Value
Offsetcount = 1
End If
Loop
ScreenUpdating = True
End Sub.
5. Sort the column using 'Sort' option.
7. Duplicate entry will be shown in red.
