HOW DO I MAKE EXCEL COMPARE THE DIFFERENCES AUTOMATICALLY?

For example, your flower names for the past two years are in column A of Sheet1 (this year) and Sheet2 (last year).

In a table b1 enter =vlookup(a1,sheet2!a:b,1,false)

Fill down. If column b is garbled, it means that it does not exist in Table 2, i.e., the number of people added. You can automatically filter the garbled characters in column B, and what is filtered out is the number of people added.

Enter =vlookup(a1,sheet1!) in b1 of the second tablea:b,1,false)

Fill down. If there are garbled characters in column b, they do not exist in Table 1. i.e. fewer people this year.

There's an easy way to do it:

You add a column to the list of last year's personnel, and the name is "logo", and fill in the number 1 in this column; This year's also adds an identification column, filled with the number 2; Copy this year's personnel list and logo after following last year's personnel list and logo, and then use the data in excel - pivot table (this knows), drag the "logo" to the big box in the middle of the layout (the default is sum, don't care), drag the "personnel list" to the left column, and click to complete. Oh, now look at it, last year, this year's absence in the logo is 1, last year's absent, this year's people are behind 2, two years are 3, and so on, even the year can be solved by this method.

Finally, put the mouse on the lower right corner of cell D2, drag the cell down until the last row, select the lower right corner of the cell in step 10 and drag it to the right until the same number of columns as **, at this time the difference between the data in the two excels has been compared.

This question is too general, and you have to see ** to find out the accurate correspondence.

The vlookup function can find out the contents of the other table by using the same column in two tables (the column items can be arranged arbitrarily, but the content should be the same), and then the different items can be compared through the formula.

To check multiple columns, repeat the operation.

There are many tutorials on how to use vlookup, which can be viewed.

You can find the difference by selecting a column in a table with relatively complete data and entering the vlookup function, depending on your specific data and needs.

In the excel software, you can check the boxes of the two columns and set the duplicate values in the conditional formatting interface, and the comparison can be completed.

1. First of all, Sun first selects the two columns of data that need to be compared in **.

2. Click on the data option in the tool.

3. At this time, click on Duplicates under the Data Options.

4. Then click Set Highlight in the list.

Duplicates. <>

5. At this time, click OK in the highlighted duplicate value window.

6. After clicking OK, you can highlight the duplicate values of the two columns of data.