How do I find large duplicates in Excel?

How do I find large duplicates in Excel?

To find duplicate entries from a single column, use the conditional formatting feature in Excel. Click the Home tab and select Conditional Formatting. Expand the Conditional Formatting menu and go to Highlight Cell Rules >> Duplicate values. The Duplicate Values field comes up.