Feb 18, 2016 Drag the two formulas to the end of your columns. Then you will have a column with Trues and Falses and next to it a column with 1s and 0s. To get a percentage you just need to take the total number of 1s, divided by the total number of entries and that will give you the percentage of cells where the two values match. Compare Two Columns For Exact Row Match. This one is the simplest form of comparison. In this case, you need to do a row by row comparison and identify which rows If you want to compare two columns and highlight matching data, you can use the duplicate functionality in conditional formatting.
Refer below images. Image of Sheet1: Image of Sheet2: Image of Sheet3 (matching ServiceNow Id): Formulas in Sheet3: Enter below formula in cell B2 & copy down - returns the matching / common ServiceNow Ids from both the sheets): =IFERROR(IFERROR(INDEX(Sheet1!$A$2:$A$100, MATCH(0,INDEX(COUNTIF(B$1:B1,Sheet1!$A$2:$A$100)+(COUNTIF(Sheet2!$B$2:$B$100,Sheet1!$A$2:$A$100).