Excel - find duplicates in a column

February 2017




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"

Related


Published by deri58. Latest update on February 6, 2013 at 04:05 AM by deri58.
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).