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.