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,
- Just select the list of values from which you want to remove duplicates
- Go to Data ribbon
- Hit the Remove Duplicates button
Here is the 15 second video tutorial I have prepared on understanding this feature.
Click here to watch on youtube.
PS: 15 second tutorials idea inspired from google tutorials.
PPS: Learn more quick tips, they make you blazing fast.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Asset Allocation Chart Turns Zombie [ChartBusters #1]||Excel Links – Bacon bits are good edition »|