Apply your favorite style using the drop-down list, then click OK. Choose the Duplicate option on the left side of the window.ĥ. The Duplicate Values dialog box will appear. Select the Highlight cell Rules option, then click on the Duplicate values.Ĥ. Click on the Conditional formatting icon.ģ. Go to the Home tab and choose the Styles group. So at first look, we have matching names but not in the same position.įollow the steps below to compare two columns with different sizes.ġ. The image below shows that the B3:B10 range is not equal to the C3:C11 range. Note: This method is not a row-by-row comparison! Compare two lists and highlight matching data In this example, we will show you how to find duplicates using conditional formatting. Sometimes, we need to compare two columns and highlight matching data. Result: Compare two columns and highlight matches and differences For example, “ BERMUDA” and “ Bermuda” are not equal the EXACT function will identify and return a “Not equal” result.įormula: =IF(EXACT(B3, C3), "equal", "different") In the example, we will use the IF and EXACT functions to find matches to perform case-sensitive cell comparisons. Result: Case-sensitive cell comparison using the EXACT function The result is “Not equal” in case the words are different. The IF formula return “Equal” if the given column contains the same name. Choose “Equal” as a second argument and “Not Equal” as the third argument of the IF function the result will speak for itself. In the following example, we will make the output easy to readable. Copy the formula down! Use the IF function to compare two columns row by row If cell B3 equals C3, Excel will write a TRUE string into column D. The result is a boolean data type in case of a match, the result is TRUE, else FALSE. ![]() Instead of using a formula, you can perform the comparison with a simple equal sign. We try to compare the text string with the corresponding item located in the same row, column C. Take a look at the first name in column B. We will compare the names row by row without using built-in Excel functions. In the picture below, here is the initial data set. Compare columns row by row using the equal sign In this section, we will show you how to compare and identify which rows contain the same value and which ones are different. Let us start to compare two columns in Excel with some detailed examples. How to compare two columns in Excel row-by-row
0 Comments
Leave a Reply. |