Deleting multiple rows with duplicate values in one column

Try this if the above doesn't work for you. You will have to paste the data somewhere else such as a new tab or next to the old data then replace. Very easy to do.

1. Select all data
2. Go to the Data Tab and click advanced under filter
3. Select copy to another location
4. Choose Location
5. Select Unique Values
6. Ok