Remove Duplicates [Quick Video Tip]

Posted on June 22nd, 2009 in Excel Howtos - 2 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

| More
Subscribe for PHD Email updates and get a free excel e-book with 95 tips & tricks

Comments
Excel Training June 30, 2009

Thanks for positing this video!

Chandoo July 2, 2009

@Excel Training: You are welcome.

RSS feed for comments on this post. TrackBack URI

Leave a comment

   Name (required)

   E-mail (required, never displayed)

   URL


If you have a question, please ask in the forums

Recommended Excel, Charting, VBA books