How To Remove Duplicates Data in Excel 2007, 2010 and 2013
1. Select any single cell or data range inside the worksheet
2. On Excel menu click Data tab, click Remove Duplicates.
3. Select any Columns that contain Duplicates or Select All
Before - After
