Excel - find duplicates in a column

October 2017


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"
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).