![]() So, different techniques are used for the same. This technique is not accurate always as values may be in other cells too. Similarly, other rows can result with the condition, or alternatively, we can drag the cursor, and the output will come automatically as below.Įxample #4 – Matching Data in case of Row Difference Here A2 and B2 values don’t match, so that the result will be “Not Matching”. If there’s a match, the result will be “Matching” or else “Not Matching”. ![]() If condition basically states if there is any match in the row. We can highlight the row difference values for different colors as per our convenience.Įxample #3 – Row Difference using IF Condition Now, matching cells are in while color and unmatched cells in white and grey color as shown below. Now, select “Row difference” from the options and press on OK. Then by pressing the F5 key on the keyboard, the “Go to special” dialog box opens. To demonstrate this technique, we’ll use the same data as above.įirst of all, the entire data is selected. Alternatively, we can drag the cursor from C2 to C6 to get the result automatically.Įxample #2 – Match Data using Row Difference Technique Similarly, the rest of the rows can be compared. So, it will show FALSE in the first row of the result column. A1 has “Raj”, and B1 has “Ankita”, which does not match. ![]() The formula is =A2=B2, which states cell A2 is compared with cell B2. We’ll use the Equal sign operator for the same.Īfter using the above formula, the output is shown below. If there is a match in both cells in a row, then it will show TRUE else, it will show FALSE. Now, we’ll insert another column called “Result” to display the result as TRUE or FALSE. You can download this Compare Two Lists Excel Template here – Compare Two Lists Excel Template Example #1 – Using the Equal Sign Operatorīelow are two lists called List1 and List2 which we’ll compare.
0 Comments
Leave a Reply. |