Google spreadsheets are evolving to have more of the functionality of excel, however there are still a few features missing.  One of these is the ability to quickly identify and remove duplicates.  A simple alternative to running a special script is to activate the addon Remove Duplicates.