Finding duplicates in Excel

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:

  1. Select the row or column
  2. Go to the Conditional Formatting section
  3. Select Highlight Cells Rules
  4. Duplicate values

Voila!  Are your duplicates are shown.  Thanks Jason G for the pro tip!