compare two columns in excel and find missing values

#Compare two columns in excel and find missing values how to#

Step 5: We must drag the formula to cell C9 to determine the other values.Step 4: Next, we need to apply the formula to get the result.Step 3: We must enter the result criteria if the logical test is “TRUE.” In this scenario, the result criteria are “Matching,” If the row does not match, we need the result as “Not Matching.”.The equals to operator, “=,” is the most commonly used logical test. Step 2: Then, apply the logical test Logical Test A logical test in Excel results in an analytical output, either true or false.Step 1: First, we must open the IF condition in cell C2.In the first example, we have got either “TRUE” or “FALSE.” But what if we need a different result instead of the default results of either “TRUE or FALSE.” Assume we need a result as “Matching” if there is no row difference and the result should be “Not Matching” if there is a row difference. How can we leave out the IF condition when we want to match data row by row. #3 Match Row Difference by Using IF Condition Therefore, we must fill in some colors to highlight the row difference values.

Then, click on “OK.”Īs we can see in the above window, it has selected the cells wherever there is a row difference. Step 4: In the next window, we must go to the “Go To Special” and choose the “Row differences” option.Now in the “Go To” window, press the “Special” tab. Step 3: Press the “F5” key to open this window.read more “F5” to open the “Go to Special” tool. Step 2: Now, we must press the excel shortcut key Excel Shortcut Key An Excel shortcut is a technique of performing a manual task in a quicker way.Step 1: To highlight non-matching cells row by row, we must select the entire data first.

#Compare two columns in excel and find missing values how to#

But today, we will show you how to use this technique to match data row by row. You might not have used the “Row Difference” technique at your workplace.

#2 Match Data by Using Row Difference Technique