Step 2: Apply the logical test Logical Test A logical test in Excel results in an analytical output, either true or false.Step 1: First, open IF condition in cell C2.In the first example, we have got either TRUE or FALSE as a result, but what if we need the difference result instead of the default results of either “TRUE or FALSE.” Assume you 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 Now fill some color to it to highlight the row difference values. After selecting “Row Difference,” click on “Ok.”Īs you can see in the above window, it has selected the cells wherever there is a row difference. Step 4: In the next window, “Go To Special” choose the “Row Difference” option.Now in the “Go-To” window, press the “Special” tab. Step 3: Press the F5 key to open this window.
Probably you have not used the “Row Difference” technique at your workplace, but today, I will show you how to use this technique to match data row by row. #2 Match Data by Using Row Difference Technique
