Excel - find duplicates in a column

October 2016


How to easily identify the duplicates present in the same column, under Excel?


- Select the column
- Click on "Conditional formatting"
- Then "Highlight Cell Rules"
- Select "Duplicate value"
- Then "Ok"

Related :

This document entitled « Excel - find duplicates in a column » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.