Comparison of multiple columns of data in the same row in Excel

We often compare units in the same row at work. How can we do this in this case? In fact, Excel is a medium method for comparing cell data. First, let's take a look at the data we want to compare. We will use the two examples in the same industry as an example.

650) This. width = 650; "Title =" 110.jpg" src = "http://s3.51cto.com/wyfs02/M02/47/1A/wKiom1P20OODCkc2AABiMwmvbtU399.jpg" alt = "wkiom1p20oodckc2aabimwmvbtu399.jpg"/>

For comparison between A1 and B1, we can use the formula = A1 = a2 in C1;

Comparing A2 and B2, we also use = a2 = b2. We noticed that the data in these two cells is strictly different, but the formula returns true. this makes a conclusion that it is case insensitive to compare two cells by equal signs. To be case sensitive, use the exact () function.

Numbers A3, B3 A4, and B4 are case-insensitive. Therefore, there is no objection to the comparison of equal signs.

A5 and B5. Why is false returned .? There is a green hat in the upper left corner of A5, indicating that it is in text format. Text 3 and number 3 are certainly different.

Is the result of comparing A2 and B2 using the comparison function exact ().

650) This. width = 650; "Title =" 111.jpg" src = "http://s3.51cto.com/wyfs02/M02/47/1A/wKiom1P21ESSW_K0AABxxf5WDkQ067.jpg" width = "424" Height = "139" alt = "wkiom1p21essw_k0aabxxf5wdkq067.jpg"/>

 

Here you may wonder what to do if it is three or more columns of data in the same row.Use = A1 = b1 = C1 or exact (A1, B1, C1.The answer is, of course, no. = A1 = b1 = C1 why not? The formula is that the A1 = b1 result is true or false in the order of mathematical operation. This result is definitely not the result you want to compare with the value in C1.

Exact (), not to mention, can have only two parameters.

 

What should we do if we compare data with multiple columns in the same row?

My method is to use the IF function. If you have a better way, let's talk about it.

Is to use the IF function to compare three columns of data in the same row.

650) This. width = 650; "Title =" 113.jpg" src = "http://s3.51cto.com/wyfs02/M00/47/1D/wKioL1P214qjf0YKAACKFGy3SYo311.jpg" width = "469" Height = "166" alt = "wkiol1p214qjf0ykaackfgy3syo311.jpg"/>

The logic of this formula is: If (IF)A3 = B3, then compare B3 and C3 and return values. That is, if A3 and B3 are the same, B3 is compared with C3, if B3 and C3 are the same, isn't A3 the same as C3? If A3 and B3 are different, the third parameter, false, and third parameter of the IF function should be omitted.

 

If it is four columns in the same row, it is nothing more than if nesting.

650) This. width = 650; "Title =" 114.jpg" src = "http://s3.51cto.com/wyfs02/M00/47/1D/wKioL1P22YiAb6R7AAChNq4i8iU738.jpg" width = "496" Height = "158" alt = "wkiol1p22yiab6r7aachnq4i8iu738.jpg"/>

 

The above is a simple comparison of multiple columns in the same row. If you have a better method, please let me know and correct it more. Thank you.

This article from the "GUO Yong technology blog" blog, please be sure to keep this source http://guoyong.blog.51cto.com/408495/1543467

Comparison of multiple columns of data in the same row in Excel