Duplicates in the same column are easy to find by sorting, filtering, and using conditional formatting. When none of those are an option, try this simple formula ...