How to find the difference between two columns of excel data that are partially the same?

The data in the two columns of excel are partially the same. Find out the different methods:

Method 1: Shortcut key [Ctrl]

First select the desired The contents of two columns of cells, in this case the range B3:C18. Then press the shortcut key [Ctrl], and the cell with different content from the cell on the left will be automatically selected. Then add a text color or cell background color to this content, and different content will be displayed more intuitively for subsequent viewing.

Method 2: Use the positioning function of Excel

The positioning function of Excel is also very powerful, it can be set according to the user Conditions quickly locate the specified content area.

Specific operation: Select the content in the two columns of cells that need to be targeted, press the key combination [Ctrl G] to open the positioning function and select [Positioning Conditions].

There are many conditions to choose from. Select [Cell with Difference in Row Content] here and confirm, and you can automatically locate cells with different data contents in the two columns.

Method 3: Use formula search

Excel has a large number of built-in function formulas to assist in data processing, including an EXACT comparison function. First select a blank cell to the right of the data to be compared, in this case cell D3. Then enter the following formula in cell D3:

=IF(EXACT(B3,C3)=TRUE,"Same","Different")

It means, compare B3 and The content in cell C3 displays "Same" if the contents are the same, and "Different" if the contents are different.

After entering the formula in D3, drag the cell downward so that the cells corresponding to the rows of data that need to be compared are filled with this formula. You can see the comparison results!

Recommended: "excel tutorial"

The above is the detailed content of How to find the difference between two columns of excel data that are partially the same?. For more information, please follow other related articles on the PHP Chinese website!