Excel - find duplicates in a column

July 2016




Issue


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

Solution


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

See also :

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.