Remove Duplicates [Quick Video Tip]

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

Spread some love,
It makes you awesome!

More...

Posts & Navigation

Tags: 15sectuts, excel 2007, howtos, remove duplicates, ribbon, screencasts, unique items, videos

Comments

Excel Training June 30, 2009

Thanks for positing this video!

Chandoo July 2, 2009

@Excel Training: You are welcome.

Cyril Z. April 16, 2010

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)

Cyril

Chandoo April 17, 2010

@Cyril.. good find. Pls. note that this approach works even in 2003. (more here: http://chandoo.org/wp/2008/06/19/quickly-display-unique-items-in-an-excel-list-using-advanced-filters/ )

Jackie Edwards July 14, 2010

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

RSS feed for comments on this post. TrackBack URI