Ask a question »

Excel - find duplicates in a column

May 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"

For unlimited offline reading, you can download this article for free in PDF format:

See also

In the same category

Published by deri58.
This document entitled « Excel - find duplicates in a column » from CCM ( 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.