Excel - How to remove duplicates entries from a column

Ask a question

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.
Jean-François Pillou

Jean-François Pillou - Founder of CCM
Better known as Jeff, Jean-François Pillou is the founder of CommentCaMarche.net. He is also CEO of CCM Benchmark and digital director at the Figaro Group.

Learn more about the CCM team