In Excel 2013, you can remove data by using “Remove Duplicates” easily. You can select and unselect the data that you want. And you will how many duplicate data that exist, how many duplicate data that has been removed and how many unique data. Check the details below!
How to remove duplicates data in Excel 2013