Removing Duplicates in Excel 2010 (Feb 2012)

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”,).