If you have created lists in Excel you might have thought to check if it has any duplicates. It could be data you’ve imported or data that has been entered. Perhaps you have shared the spreadsheet and you want to make sure that there aren’t any and remove them if there are.

Excel has a useful feature called remove duplicates that does just that. It will tell you how many duplicates there are and you can then choose to remove them.

Like many of Excel’s tools this one is powerful and easy to use. In this video I show you how to use it.