How to find duplicate data in Excel2007

You may often need to find duplicate data in Excel tables and delete them, and it is impractical to find a lot of data. Here are two small ways to help you deal with duplicate data.

Method 1: Highlight duplicate data

You can highlight repetitive data so you can find them and avoid repetitive entries. The procedure is as follows:

First, select the scope of the duplicate data you want to find. For example, if you are looking for duplicates in the employee number, select the "Employee Number" column.

Then on the Start tab-> Conditional formatting-> highlight the cell rules-> duplicate values.

On the Duplicate Value dialog box, select the format you want to highlight the duplicates, and then determine.

It's done! Repeat the content at a glance, so you can take appropriate measures slightly.

Method 2: Easily remove duplicate data

You can use Excel to remove duplicate data and delete duplicates. The procedure is as follows:

Select the range for which you want to delete duplicate data. For example, select the entire table.

Then-> deletes duplicates on the Data tab.

A Delete Duplicates dialog box pops up. Check which columns you want to find duplicates in which columns, and make sure.

Excel checks for duplicate values, deletes records that contain duplicate values, and then pops up a box to tell you how many deleted (or no duplicate records were found):

Or

What if I have other problems in use?

Don't worry, we have a post on the Microsoft Community Forum for this article to make it easy for you to discuss in your post. If you have any questions, you can reply in your post.