Home Excel Content

How to Find Duplicates in Excel

Tips 2022-05-19 15:05:50 Excel 220

To find and highlight duplicate values in Excel, execute the following steps.

1. Select the datas.

2. On the Home tab, in the Styles group, click Conditional Formatting.

3. Click Highlight Cells Rules, Duplicate Values.

4. Select a formatting style and click OK.

Result. Excel highlights the duplicate names.

How to Find Duplicates in Excel1

Note: select Unique from the first drop-down list to highlight the unique names.

How to Find Duplicates in Excel2