If you want to remove duplicate entries in excel, just choose the area you want to make your changes. Click on Data –> Filter –> Advanced Filter and click on «Unique records only». You can replace the data or even copy them somewhere else.
Imagine having an excel file with 50.000 filled cells with many empty cells between them and you want to remove them. It is very simple:
Edit –> Go To
Click on Special and choose blanks.
Then just right click in one empty cell from the selection and choose delete row.
It is that simple 😀