Shulou(Shulou.com)06/01 Report--

This article shows you what Excel data comparison skills are, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Today, the editor will tell you some very simple and practical Excel data comparison skills to help you easily deal with Excel~.

1. Shortcut key pair

1.Ctrl +\

We always see a lot of data in Excel tables. When we need to compare the two sets of data in Excel, there are a lot of friends who don't know how to do it quickly. In fact, to quickly complete the data comparison, we only need to use the [Ctrl] + [\] shortcut keys to do it.

2.Ctrl + G

To quickly compare the data in the Excel table, we can also use the [Ctrl] + [G] shortcut to call out the positioning window, and then we can click [location condition]-[Row content difference cells]. In this way, the result of data comparison will appear in front of us quickly, which is very simple.

II. Comparison of formulas

1.IF function

As we all know, the IF function formula in Excel is very powerful and can help us do a lot of operations, and it can be easily done with this function if we want to quickly compare the data in Excel. We can enter [= IF (numerical cell 1 = numerical cell 2, "same", "different")] in the Excel cell, so that we can quickly compare the differences in the data.

2.COUNTIF function

When we want to compare the data in Excel, we can also use the countif function to help us do so. The number of values can be judged by relative references. if the number is 0, it proves that the two data are different.

3.EXACT function

Of course, we can also use the EXACT function to quickly determine whether the two sets of values are the same. We can enter [= EXACT (numerical cell 1, numerical cell 2)] in the cell, so that the comparison of the data will soon appear in front of us.

All right, the above is a very powerful and practical data comparison operation in Excel. I believe we all understand it. If you need it, please try it.

What are the skills of Excel data comparison? have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.