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

To pinpoint duplicate entries, apply Excel's conditional formatting feature: Open the Excel worksheet containing the data in question. Select the column or range you want to inspect for duplicates.

Excel then tells you how many duplicates it has removed. In my example, 50 appeared in the list three times, and 19 appeared twice, so Excel has removed two 50s and one 19, totaling four duplicate ...

There’s no built-in duplicate rule for Excel’s Data Validation feature, but you can combine the feature with the COUNTIF() function to get the job done. To do so competently, you need to know ...

There are many ways to find duplicates in a Microsoft Excel data range—conditional formatting being one of the most commonly used. When the rule is TRUE, the format stays until the condition is ...