Excel - find duplicates in a column

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

Knowledge communities.

• Forum
• Excel forum

This document entitled « Excel - find duplicates in a column » from Kioskea (en.kioskea.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.