This example teaches you how to remove duplicates in Excel. Click any single cell inside the data set. On the Data tab, click Remove Duplicates.
www.excel-easy.com