How to remove duplicates in excel

Here is how to remove duplicates in excel.

  • Select the range of cells you wish to remove duplicates for.
  • Click on the Data tab, click Remove Duplicates under the Data Tools group.

excel data tools remove duplicates

  • Select the columns you want to remove duplicates and click OK.

Leave a Reply

  Subscribe  
Notify of