Excel comes with a built-in tool that makes cleaning your data quick and easy. Here's how it works. When you have duplicate data that you want to remove from a single column in your dataset ...

Excel will now highlight the duplicate values in the selected range in your chosen format. Keep in mind that any value that occurs multiple times will be highlighted in the same way. You can use ...

Select columns from which you want to remove duplicates. Click OK. Excel displays a message showing the number of duplicate ...