How to compare information in excel table

How to compare information in excel tables?

1. Open an excel table that needs to compare two columns of data to see if they are the same.

Recommended: "excel tutorial"

2. Select a cell where you want to put the judgment result.

3. Enter the equal sign = in this cell.

4. Select the comparison data in the first column,

5. Enter an equal sign again.

#6. Select the data of the corresponding cell in the second column and press the Enter key.

#7. Place the cursor in the lower right corner of the first judgment value cell, and drag downward when the cursor turns into a cross.

#8. All judgment results are displayed. false means that the data in the two columns are not the same, and true means that the data in the two columns are the same.

The above is the detailed content of How to compare information in excel table. For more information, please follow other related articles on the PHP Chinese website!