Okay I know this isn't some amazing programming technique - but a great reference for me for years to come regarding removing duplicate records in an Excel worksheet.

CMQ: Tips and Techniques