Excel: Remove Duplicates in List

This is a common request, how can I remove duplicate entries in my Excel list or database, they used to be called databases until Microsoft decided to start calling them lists.

In more recent versions of Excel this is really easy to do, in older versions it is easy too just different and not quite so obvious but you will see it is really straighforward.

Here is a video tutorial to show you how.