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"
This document, titled « Excel - find duplicates in a column », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).