How to compare whether the contents of cells in two columns are the same?

Method to compare whether the cell contents in two columns are the same:

1. Open an excel table that needs to compare whether the data in two columns are the same. Select a cell where you want to put the judgment result.

#2. Enter the equal sign = in the cell and select the comparison data in the first column.

#3. Enter an equal sign again and select the data of the corresponding cell in the second column.

4. Press the Enter key to display the judgment result

5. Place the cursor at the first position In the lower right corner of the judgment value cell, drag down when the cursor changes to a cross. You can judge all the data in the two columns of cells.

Recommended learning: Excel Basic Tutorial

The above is the detailed content of How to compare whether the contents of cells in two columns are the same?. For more information, please follow other related articles on the PHP Chinese website!