Remove Duplicates [Quick Video Tip]

Excel Howtos - 5 comments

remove-duplicates-excel 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
  • Bingo…

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.

PPPS: There are 4 more ways to remove duplicates: 1 2 3 4


Hello Awesome...

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.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.

Related articles:

Written by Chandoo
Tags: , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

5 Responses to “Remove Duplicates [Quick Video Tip]”

  1. Chandoo says:

    @Excel Training: You are welcome.

  2. Cyril Z. says:

    Hello Chandoo,

    I've just found another tip which is powerful in 2007.

    Go to Data / Sort and Filter area -> Advanced... /

    There is a checkbox "Extract without duplicate" in the dialog.
    You can extract the list wihtout duplicate in another sheet (awesome for creating reference list for data validation)


  3. Jackie Edwards says:

    This works perfectly! I always come to you before consulting the Excel help. Thanks for helping us Excel want-to-be experts look great!

  4. [...] is no wonder that I have written extensively about it (here: 1, 2, 3, 4, 5, 6, 7, [...]

Leave a Reply

« »