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

Today, I will talk to you about how to compare Excel two columns of data is the same, many people may not know much, in order to let you know more, Xiaobian summarized the following content for you, I hope you can harvest according to this article.

Excel compares whether two columns of data are the same: first, there are two columns of data A and B, prepare to judge whether the two columns of data are consistent and return the comparison result in column C; then set the formula [=if(A1=B1,"√","×")] in column C, and return the judgment result of the first row to column C; finally pull down the formula, that is, you can complete the pre-goal.

1. As shown in the figure, there are two columns of data A and B, ready to judge whether the two columns of data are consistent, and return the comparison result in column C;

2. Set formula =if(A1=B1,"√","×") in column C, click Enter, and the judgment result of the first row will return to column C;

3, pull-down formula, that is, can complete the pre-goal.

After reading the above, do you have any further understanding of how to compare the two columns of excel data to see if they are the same? If you still want to know more knowledge or related content, please pay attention to the industry information channel, thank you for your support.

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.