Hello! I have two reports with the mismatched accounts in their appropriate sections. I need to compare what section is missing what accounts. Basically, it's two ways comparison. My approach was with vlookup and then highlight the missing accounts, but it is a tedious process and maybe there is more advanced approach. I am attaching the sample file. Much appreciated your insights!
11.4 KB Views: 10