Removing Duplicates in Excel 2010

Removing Duplicates in Excel 2010

This 5 minute YouTube video shows how to remove duplicates from Customer Data in Excel 2010 using a Customer ID number as the basis for duplicate removal.

It uses two techniques – the first using the ‘Remove Duplicates’ button in Excel 2010 and the second using a formula which allows you to see the duplicates individually before removing them.  The formula used in the video is: =IF(A2=A3,”Duplicate”,).

 

 

Share:

0 Comments on "Removing Duplicates in Excel 2010"

Would you like to share your thoughts?

Your email address will not be published. Required fields are marked *

Leave a Reply