This is just a short video showing how easily Excel 2007 deals with duplicate data. A task that whilst not tricky in earlier versions, was certainly more time consuming!
If this is received well, I may do a few more 'shorts'