Kioskea
Recherche
Ask a question »

Excel - find duplicates in a column

February 2015


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"
For unlimited offline reading, you can download this article for free in PDF format:
Excel-find-duplicates-in-a-column.pdf

See also

In the same category

Published by deri58
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.