How to Identify Duplicate Items in Excel. Microsoft Excel helps you find duplicate values and identifies these cells with a color marker on your worksheet. This formatting lets you avoid the ...

Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.

Click the "Data" tab in the Microsoft Excel 2007 ribbon and locate the Data Tools group. Click on the "Remove Duplicates" item to bring up the Remove Duplicates dialog box.