Check whether the content of the two columns of ** peers is 100% consistent, including the spaces between the words and the case of the letters are all in the checked indicators (Figure 1). In this case, you need to use the act function, no matter what you check, it's a breeze, whether it's content or format, exact will use a magnifying glass to help you find the difference.
For such an accurate ** check, the operation is very simple. First of all, let's get to know a text function "exact", which is used to detect whether the content in two cells is exactly the same. It is important to note that the "exact" function is tested according to strict criteria, with both the case and spaces of the letters being detected (Figure 2).
The specific operation is as follows: enter the formula, equal sign, exact, and the parameters in the function in the first row of the check result, which is the cell that needs to be checked, click the c2 cell, comma, and then click the d2 cell, complete the closing bracket, and the exact formula is completed (Figure 3).
We press back to look at the result, and it shows true, and the judgment is true, which is what it means to check the agreement (Figure 4), but what we need is to display the words "correct" instead of English, which requires adding an "if" function in front of the formula, we enter "if" in front of the exact formula, and after the formula, enter the text we need to display the result: "correct" and "false", and finally complete the closing bracket (Figure 5).
It's done, press enter to see the results. The result of the judgment displayed in text is displayed (Fig. 6), and the result of the comparison of all contents is displayed by filling in the formula (Fig. 7).
Using a screening tool, we can filter out all the inconsistencies (Figure 8).
Students who like today's content, like and support, follow me, and continue to share practical office operation skills!