Sometimes duplicate data is useful, sometimes it just makes it harder to understand your data. Use conditional formatting to find and highlight duplicate data. That way you can review the duplicates and decide if you want to remove them. Select the cells

In Excel 2007 and later versions of Excel, select the Developer tab, and then select Macros in the Code group. Note: If you don't see the Developer tab, you may have to turn it on. To do this, select File > Options > Customize Ribbon , and then

Click the Home tab, and then click the Conditional Formatting button in the "Styles" area of the toolbar. Select Highlight Cells Rules on the menu, and then Duplicate Values. Now, choose how you'd like Excel to highlight the duplicates in yo