We’ve looked before at removing duplicates in Excel. But what if you just want to find duplicates to evaluate them?
Try this:
1) Export data from GP to Excel. You can export from SmartList or use a refreshable Excel report.
2) Highlight the information and pick Conditional Formatting | Highlight Cell Rules | Duplicate Values
3) Click OK to highlight duplicates in Red.
4) You can filter the list by turning on filters and picking filter by color to only see duplicates without removing anything from the list.