« Office365 HTML Format | Main | Restarting Firefox Trick »

Excel - Remove duplicates

Imagine you have a list that contains duplicates, and you want to delete the duplicates. No need to do this manually --- let's use Excel's "Remove duplicates" feature!

Click on the image to see it full-size
Removeduplicates

This is one of my favorite TechBits pictures. I wish there were 3 of me to do my work!
Duplicate Craigs!

Note: Another option to get rid of the duplicates is to filter for unique values. Filtering temporarily hides duplicate values, where removing duplicate values permanently deletes the duplicate values. See this Microsoft help page for more information about both options.

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

That picture reminds me of a nightmare I had once...

Post a comment