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"