HOW DO I FIND DUPLICATE DATA IN EXCEL?

Solution: Method 1: Function formula method.

Step 1: Enter your data.

How to find data with duplicate names in excel-1

Step 2: Insert the column that needs to display the repeat prompt, here column C is taken as an example.

excel how to find data with duplicate names - 2

Step 3: Insert the formula (see Figure 3) and then populate the drop-down sequence. If you don't understand the formula, press F1 to find the help file.

excel how to find data with duplicate names - 3

Step 4: Filter the data.

excel how to find data with duplicate names - 4

Method 2: Non-formula method.

This method comes with Office2007, and you can find duplicate data without formulas.

Step 1: Enter your data.

excel how to find data with duplicate names - 5

Step 2: Select the column or region that needs to be checked for data duplicates, then click the "Start" tab, find the "Style" option group, click the "Conditional Formatting" option, and select "Duplicate Values" in the first option "Highlight Cell Rules" in the drop-down list. As shown in the figure below:

excel how to find data with duplicate names - 6

Step 3: Set the style of duplicate value display in the pop-up "Duplicate Value" dialog box.

excel how to find data with duplicate names - 7

Step 4: Filter the data by color.

Excel how to find data with duplicate names - 8

Suppose you want to set the highlighted data region in a1:f100, select a1:f100, format, conditional formatting, formula, and enter "=countif($a$1:" in the box

f$100,a1)>1", and then select a fill color in the format settings below, OK, OK, as long as there are duplicate numbers in the area, the high color will be highlighted.

The practice on the first floor is also a way to set up conditional formatting, but conditional formatting often has to be combined with functions to play a powerful role, otherwise it is not too troublesome to judge whether it is repeated one by one.

How to find duplicate data in **?

Select the Data option in the menu bar. In the toolbar below Data Options, select Highlight Duplicates. Highlighted duplicates are automatically filled with special colors, so that you can visually see the duplicates, detailed steps:

1. Two new columns of data have been created.

2. Then select the data option in the menu bar.

3. In the toolbar below Data Options, select Highlight Duplicates.

4. Then the drop-down menu will pop up, and select Set Highlight Duplicates. (Note here: two columns of data need to be selected in advance).

5. Then there will be a pop-up area to set two columns of data, and you don't need to set it after you select it, and you will automatically set the data area manually if you don't select it.

6. Highlighted duplicates will be automatically filled with special colors, so that you can see the duplicates intuitively.

Here's how to quickly find missing excel duplicate data:

Tools Raw materials: Lenovo Yoga 14C, Windows 11, Excel 2021.

1. First open the excel document.

2. Select the column that needs to find duplicates. Zheng Hui.

3. Click Conditional formatting.

4. Click to highlight the cell rule and click the duplicate value.

5. Click OK in the pop-up window.

6. Finally, you can quickly find duplicates.