Roger that. In my case, just yesterday I created a process to upload new pricing information from one of our vendors. For whatever reason, they usually have duplicated part numbers on the spreadsheet (fortunately with the same pricing information for each) and I've included a step to delete these dupes. I haven't had to deal wtih dupes in so long that I found myself looking for "new and improved" ways to handle the problem. Thought it was very coincidental that in my inbox this morning I got a SqlServerCentral mail discussing the very topic.

While my solution is a "one-time" fix, it must be done every time I work with this vendor's spreadsheets (about once-per-month).