Removing duplicate pieces of data: Click on the image or this text to see how this task is carried out in an animated sequence of images. As you can see in the example, you need to consider what is a duplicate record by deciding which columns you want to compare. If you need additional information, please read the Excel help page on this topic. 12