Shulou(Shulou.com)11/24 Report--

The original title: "quickly check the two forms to find out the differences." "

If I give you two tables, how can you quickly check them and find out the different data contents? Today, I would like to share with you several effective and simple ways to solve this problem.

1. Compare two columns of data and check the two columns of data to find out different data.

Select two columns of data, press the "F5" key, enter the "positioning conditions", and check the "row content difference cells" to determine.

We can take a look at the checked results.

2. Highlight the rows of different cells by comparing the two tables, highlighting the rows of different cells.

Sheet1 and Sheet2, let's compare them. Click "data"-"sort and filter"-"Advanced", select the table in "Sheet1" in "list area". Select the table in "Sheet2" in "list area" and make sure. Then, color all the data, and finally display the cells.

The end result.

3. Highlight different data cells to check two tables and highlight different cells.

Select the data in Sheet1, enter "start"-"style"-"conditional formatting"-"New Rule"-"format only the cells containing the following", set it to "not equal to" in "between", select the first cell in "Sheet2" in the back region, and then change the "absolute reference" to "relative reference". Click "format"-"fill", set a color, and make sure.

The final results are as follows:

4. Check and display the comparison results. Check the two tables through the function formula.

Here, we check the tables in Sheet1 and Sheet2, use function formulas in Sheet3, and then populate them into other cells.

= IF (Sheet1Sheet2roomA1, "Sheet1:" & Sheet1roomA1 & "vs Sheet2:" & Sheet2roomA1, "")

The final result is as follows: in Sheet3, the contents of different data in Sheet1 and Sheet2 tables will be displayed in cells, such as "Sheet1:XX vs Sheet2:XXX". It is more convenient for us to view and compare these results.

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.