Excel - How to remove duplicates entries from a column

December 2016


Excel - How to remove duplicates entries from a column


Here's a simple method to remove duplicates entries from a column:
  • Click on the Data menu.
  • Filter.
  • Advanced Filter.
  • In the List Range field, select the column where the duplicates are.
  • Check "Unique record only" and click on OK.

Related :

This document entitled « Excel - How to remove duplicates entries from a column » from CCM (ccm.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.