How to label the same data in Excel

Implemented with conditional formatting.

If it is in column D, then select column D first, and then.

Formatting – Conditional formatting--- cell numeric --- is equal to ---a, and the format selection is red for the pattern. Then the dot is added, the cell value --- is equal to ---b, and the format selection pattern is black. Are you sure. That's it.

Open the table, assuming the data you want to process are all in column A, press alt+f11, double-click sheet1, copy the following **, press f5, sub abab().

dim i as integer

for i = 1 to 5000

if sheets(1).cells(i, 1).value = "a" and sheets(1).cells(i, 1).value <>"" then

sheets(1).cells(i, 1).select

withcolorindex = 5

end with

end if

if sheets(1).cells(i, 1).value = "b" and sheets(1).cells(i, 1).value <>"" then

sheets(1).cells(i, 1).select

withcolorindex = 6

end with

end if

if sheets(1).cells(i, 1).value = "" then

exit sub

end if

next i

end sub

If you can be sure that your data sees no spaces, you can put this.

if sheets(1).cells(i, 1).value = "" then

exit sub

end if

Front'can improve the execution efficiency, and currently only 5000 rows can be processed.

Open the Excel you want to find. Copy the content of the second ** to the content of the first **, and select the area where you want to find the same dataClick Conditional formatting below to get started. Click Highlight cell formatting, and then tap Duplicate values.

Set the color of the duplicate value display, and click OK to mark the duplicate valueDetailed steps:

1. Open the excel** you need to find.

2. Copy the content of the second ** to the content of the first **.

3. Select the area where you want to find the same data, and click Conditional formatting below Start.

4. Click Highlight Cell Format, click Duplicate Value.

5. Set the color of the duplicate value display, and click OK to mark the duplicate value.

You can find duplicates through the function relation, take the computer excel operation as an example, find the duplicates of **1 and **2 names, the operation process is as follows:

Operating Equipment: Dell ComputerOperating system: win10Operating Software:

excel**The first step is to open the first excel** and enter =if(a2=), as shown in the figure below.

Step 2: Switch to the second worksheet, select the region and press enter, as shown in the figure below.

Step 3: Go back to Sheet 1 and complete the formula =if(a2=sheet2!).a2:a9,"Yes","Nope"), as shown in the figure below.

Step 4: Move the cursor to the lower right corner, drag the cells to complete the copy of the function, and then you can find the duplicate data, as shown in the figure below.

When you are in excel, you find that there are a lot of the same data in excel, so how to find the same data in excel and mark it, how to find the same data in excel and mark it, let's take a look.

1. First of all, open the Excel** that needs to find the same data and mark it, click the same data that needs to be found, and click [Fill Color] under [Start].

2. After filling the background color of the data in red, double-click the [Format Brush] function, and the green dotted box will appear.

3. Then find the [Find and Replace] function, you can also use the shortcut keys: Ctrl+F, Ctrl+H, enter the data you need to find in [Find], and click [Find All].

4. Finally, in the found data, click to mark the same data, and mark one item for each click.

2. Enter =if(countif()) in the blank space of the same line corresponding to the name in sheet1

3. Then switch to sheet2, select all names and press enter.

4. Switch to sheet1 again, and this function becomes =if(countif(sheet2!a1:a44))。

5. Finally, add the function =if(countif(sheet2!$a$1:$a$44,a2),"s","f"After the input is completed, press enter, and those displayed as s are the students in this class, and those displayed as f are not.

Pull down from this row to fill in and all students will be screened.

Here's how: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.

Tool Material: Excel**.

1.First, open Excel and select the two columns of data that need to be labeled.

2.Then click on the highlighted duplicates in the data in the menu bar. Hole ruler.

3.Then click the arrow below Highlight Duplicates and select Set Highlight Duplicates in the drop-down menu.

4.At this time, a Nachain high confirmation window will pop up, click to confirm.

5.Finally, if there is duplication in the two columns of data, it will be marked with different colors.

In Excel, the duplicate data mark in a column can be marked in Conditional Formatting - Highlight Cell Rules - Duplicates, the specific method is as follows:

1. Here take Excel 2013 version as an example, first open the Excel sheet on the computer where you want to mark a column of duplicate data.

2. After selecting a column of data, select [Conditional Formatting] at the top of the page.

3. Then click [Highlight Cell Rules].

4. After entering the highlighted cell rules page, select [Duplicates].

5. Then select the color of the duplicate data on the pop-up page, and then click [OK] to mark the duplicate data in Excel**, here take light red as an example.