How to remove duplicates data in Excel 2013

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
  1. Select your data
  2. Click “DATA”
  3. Click “Remove Duplicates”
  4. Excel 2013 Data remove duplicate
  5. You can select and Unselect data on the tab and then click “OK”
  6. Excel 2013 Data remove duplicate1
  7. And the duplicate data will show up and then click “OK”. 
  8. Excel 2013 Data remove duplicate2