Remove Duplicates [Quick Video Tip]
It is very surprising that so many of us are still not aware of this extremely powerful tool in Excel 2007. Just with a click of the button, you can remove all the duplicate values from a list / table. To remove duplicates, (1) Just select the list of values from which you want to remove duplicates (2) Go to Data ribbon (3) Hit the Remove Duplicates button (4) Bingo…