MicroKnowledge, Inc.
21 British American Blvd.
Latham, NY 12110
Phone: 518.786.1181
Fax: 518.786.6221

MK Blog


« Return to MK Resources

Excel: Identify and Remove Duplicates
Posted: July 8, 2012

If you ever get a large list of people, products, transactions, etc. in Excel – it’s always a good idea to go through the list to make sure everything “looks right.” And one of the biggest culprits in making data “look wrong” is duplicate entries.

Fortunately Excel has a handy feature called Remove Duplicates, which since 2007 has made its home on the Data tab. But, there is one problem – Excel automatically removes the duplicate entries, even if some parts of the entry were different. No questions asked.

For instance, let’s say I had some customer information, but the duplicate customer entries weren’t ENTIRELY identical – one had an updated phone number and the other had an updated address. If I tell Excel to remove duplicates based on the same name I get something like this:

I don’t know which of the duplicate entries got removed, and when deleting I HATE to not know what I’m removing.

So let’s INDENTIFY our duplicate entries instead using Conditional Formatting. First, highlight the column that may contain duplicates. Then on the Home tab click Conditional Formatting, Highlight Cells Rules, Duplicate Values. Click OK and, voila! – all the duplicates appear in red.

Now you can go through the list and remove or keep the correct entries!

Author: Ryan Donelan

Remember, if you are a MicroKnowledge customer and have a software question to ask, feel free to contact us at any time by using our Support link at the top of the site. Your question might be featured in our next blog entry!

Do you have a related tip to share? Leave a comment. We’d love to hear from you!

Category: Tech Tips

Leave a Reply

microknowledge.com is proudly powered by WordPress | Design by Trampoline-Design | Follow Us on Google + Google+ | Subscribe to RSS Subscribe to RSS