Remove Duplicates in Excel

I’m often asked how to remove duplicate entries in an Excel list or database, they are the same thing but Microsoft have more recently called them lists. Thankfully it is easy to do, particularly on more recent versions of Excel. Not that it was difficult in older versions just different.

How many times have you got a list and knew that there were duplicates in there that needed to be removed or you wondered if there were duplicates? This can be any type of list, it might be one that you have for your shopping or a list of names for a mail merge, whatever it is you will want to get rid of those duplicates.

Here I show you how to do this on the more recent versions and how to do on the older versions.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, Office 2010. Bookmark the permalink.

One Response to Remove Duplicates in Excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s