How to find out two identical contents in excel

1. In Excel 2010, create a new Excel document, and then open it as shown in the following figure.

2. Create two columns of data in the excel document, and ensure that at least one or more of the two columns of data is the same, as shown in the figure below.

3. Select the two columns of data, as shown in the following figure.

4. After selecting the two columns of data, find "Highlight Cell Rule" under Conditional Formatting, and then find and click the Duplicate Value button.

5. In this way, the duplicate value is displayed, in order to make the duplicate value highlighted, you can set the color for the duplicate value cell and text.

6. Set the duplicate cells to green, set the cells to dark green, after the setting is completed, click OK, the best effect is as follows.

1.Suppose that there are two **: s1 and s2, both of which have data (including duplicates), see the figure:

2.You can use the function if( ) and the function countif( ) in an empty cell in one of the tables and enter the formula =if(countif('s2'!a:a,a1)=1,"Repeat","Do not repeat") to achieve it.

3.Here, in S1 worksheet, cell B1 enter the formula: enter the formula =if(countif('s2'!

a:a,a1)=1,"Repeat","Do not repeat")。Here you can see that the first one has been prompted as a duplicate.

4.Next, point the mouse to the lower right corner of cell B1, and drag the mouse down when the black cross appears. (In order to fill all the following cells with formulas).

5.You can take a look at the renderings and the final result.

6.Finally, through the data - automatic filtering - duplicates, all the duplicates are filtered out, and then deleted, and the rest is not duplicates.

7.Actually, you can also use the function vlookup( ).

Two**: S3 and S4, both have data (including duplicates), if the content is the same as above.

In the S3 worksheet, cell B1 enter the formula: =VlookUp(A1,'s4'!a:a,1,0)

8.The rest of the steps are the same as above, which is to drag the mouse down to fill the cells with the formula. Follow the steps above and do the rest.

9.Then, the function vlookup( ) is also different from the functions if( ) and countif( ) above, and its result is that if the content is the same, it will be displayed, and if the content is different, n a. will be displayed

10.This is achieved through function formulas, and of course there are other function formulas, which you can study for yourself.

Actually, you can achieve it without going through a formula, so let's briefly describe the steps.

The same two **: s1 and s2, both have data (including duplicates).

Copy the data from table S2 in red to S1 and put it in the same column, leaving separate rows in the middle to distinguish them.

11.Select this column, and through the Data - Duplicates - Highlight Duplicates - setting, all duplicates will be automatically filled with orange.

12.Select this column, go through the data-auto-filter-color filter, select the color that highlights the bright color (orange), and all the duplicates will be displayed.

13.Then, drag the mouse to select these items and press the delete key to delete them. The rest is non-duplicate data.

<> Select the column and set the high duplicate.

Or with a sort approach.

Find the same data in 2 Excel** and mark it as follows:

<>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.

1. First of all, list the name and data columns in two excel columns, and you need to match the data in **2 to the data in **1 according to the name.

2. Click "fx" to insert the function and select the "vlookup" function.

3. Enter the data in the function parameters in the format shown in the following figure, and convert it into the formula: =vlookup(a2,$d$2:$e$8,2,0).

4. Click OK and drop down the formula to enter the data according to the name of **2 corresponding to **1.

Here's how to find the same data for two **:

Start by selecting Conditional Formatting under the Start menu, click on the box that appears, select the first one, highlight the cell rule, and then select the duplicate value.

Once you've made your selection, he'll prompt you to set up the format, which has a lot of options for setting up, and you can also choose a custom format. After selecting, click OK, and then the two columns of the same data will be displayed in ** to show what you have set.

microsoft excel

It is a spreadsheet program (a software program that performs numerical and budgeting operations) that, like Microsoft Word, has a dominant share of the market.

It was initially a competitor to the dominant Lotus 1-2-3, but eventually it sold more and faster than it, and it became the de facto standard. It is available for both Windows and Macintosh platforms. Its main competitors are Calc, Applenumbers, and Corelquattro Pro.

Find the same data in 2 Excel** and mark it as follows:

<>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 then this function becomes slippery=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 the students in this class are displayed as s, and those that are displayed as let wide f are not.

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

The specific operations for querying duplicate data are as follows:

1.First, select two columns of data.

2.Click on "Conditional Formatting".

3.Secondly, click "Highlight Cell Rules".

4.Then click on "Duplicate Values".

5.Then click "OK".

6.In this way, two columns of the same data are found.