I need to compare two excel 2016 files and it seems to be a lengthly process and I know there's a faster better process. I'm currently using the following process...
Step 1: I need to match the name from spreadsheet A to spreadsheet B.
Step 2: Once I find the matching names, I need to confirm if Spreadsheet A's column "P" matches to Spreadsheet B's column "X" for example. I need to do this for almost 500 users and it took me almost a day of nonstop typing and searching last month.
I think there's more to this and I know there are some Exel gurus out there. Help please.