Home>Article>Topics> 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

coldplay.xixi
coldplay.xixi Original
2021-03-16 11:04:03 242677browse

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")".

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

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.

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

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.

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

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.

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

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.

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

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn