You've mentioned a way to remove duplicates from excel. But the article looks little old and the screenshots may not apply to the latest editions of Excel 2007/2010. Here is another article which explains the same in detail.
http://www.techlikes.com/2011/08/23/remove-duplicates-in-excel-20072010.html