Im trying to compare two worksheets in the same workbook that are 95% identical. sheet1 have columns A and B and contains 975000 rows and sheet2 have columns A and B and contains 1000000 rows. I need a formula to highlight/display the unique values in sheet2.
I'm using this formula...