Introduction to the method of quickly checking the contents of two tables by Excel

If you are given two columns of data so that you can find differences quickly, do you know how to do it? No, it doesn't matter. today, Mr. Wang has come to use a variety of methods to teach us to use Excel to compare data to find differences. Let's take a look.

1. Comparing two columns to find different two columns of data is more, how to compare and find different?

Use the IF function to do it, the formula: = IF (A2=B2, "same", "different").

2. There is another way to compare two columns to find differences. We can select two columns of data and then directly use the shortcut key "Ctrl +\". You can compare the two columns of data with one button to find out the differences.

3. Comparing different orders to find different columns, the contents of the two columns are basically the same, the order is different, how to compare the two columns of data to find different?

We first select these two columns, and then enter "start"-"style"-"conditional format"-"highlight cell rules"-"duplicate values". In the pop-up "repeated values" dialog box, we can set "repeat" to "unique". In this way, we can see the differences between the unique values in the two columns.

4. Compare the two forms to find the differences. The location is the same, individual data are different, find out the different content.

Copy one of the tables, then navigate to another, "right"-"paste selectively"-"minus"-"OK". If the same content is subtracted to "0", different results will be highlighted.

5, fill color select the "Sheet1" in the table, enter the "start"-"style"-"conditional formatting"-"New Rule"-"use the formula to determine the format of the cell", select the "Sheet1" in the table region, press the F4 key three times, the absolute reference will be set as a relative reference, and then enter "" less than the sign and greater than the sign, and then in the "Sheet2" select the table area, also set to the relative reference. Finally, we can click format to set the fill color.

6. Comparing two tables in different order, the contents of the two tables are basically the same, but the order is different.

We can create a new worksheet, click "data"-"data tools"-"merge calculation"-"Standard deviation" to select the reference location, and then add the two tables in turn, and finally check the "first row" and "leftmost column" to determine.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi