How to compare two columns of data in Excel to see if they are the same

Excel method to compare 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 in column C [=if (A1=B1, "√", "×")], the judgment result of the first row is returned in column C; finally, the drop-down formula can be used to complete the pre-target.

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

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

3. Pull down the formula to complete the pre-goal.

More tutorials: "php tutorial"

The above is the detailed content of How to compare two columns of data in Excel to see if they are the same. For more information, please follow other related articles on the PHP Chinese website!