How to remove duplicate rows based on some columns
In Excel 2013
- Select all Data
- Select Data Tab -> Remove duplicates
- Check 'My columns have headers' if your data has column headers.
- Uncheck all columns you would NOT like to use in comparison
- Press OK
Done