How to compare the similarities and differences between two columns of data in excel

How to compare the similarities and differences between two columns of data in excel: 1. Select the two columns of data and press the "Ctrl" key and the "/" key at the same time; 2. Enter the formula "=B2=C2" and fill it down. Enter the formula into other cells; 3. Enter the formula "=IF(B2=C2,"","not the same")".

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to compare the similarities and differences between two columns of data in excel:

Method 1:

Select two columns of data and press the "Ctrl" key and " /" key to filter out the cells with different data in the second column and the first column, and then fill them with different colors.

This method is only supported by Excel, not wps.

Method 2:

As shown in the figure, enter the formula "=B2=C2", and then fill the formula downwards into other cells, so that the formula returns the result "FALSE" indicates that the data in the left and right columns are not the same, and "TRUE" indicates that the data in the left and right columns are the same.

Method 3:

Enter the formula "=IF(B2=C2,"","not the same")", the data in the left and right columns are not the same The ones that are the same will get the result "not the same" and the ones that are the same will remain blank.

Method 4:

Enter the formula "=B2-C2". If the data in the left and right columns are different, the difference between the data will be obtained. If the data is the same, the difference between the data will be obtained. will get 0.

This method is only suitable for comparing two columns of numbers.

Related learning recommendations: excel tutorial

The above is the detailed content of How to compare the similarities and differences between two columns of data in excel. For more information, please follow other related articles on the PHP Chinese website!