This has been another thorn in my side. I know how to do it using formulas (as you may have read in my older blog posts) but I was just shown a super easy way to find them.
Its almost embarrassingly easy:
- Select the row or column
- Go to the Conditional Formatting section
- Select Highlight Cells Rules
- Duplicate values
Voila! Are your duplicates are shown. Thanks Jason G for the pro tip!