Hello,
I've attached a simplified/desensitized version of what I'm working with.
Two data source sheets, and the report sheet I am building.
Sheet 1 ("Agreed Access") is the access an agent should have.
Sheet 2 ("Current Access") is the access an agent has currently.
Sheet 3 ("Report") is where I'm trying to build the report.
I used Deduplicate of data to create my list of agents and emails on the Report sheet.
I'm trying to figure out how to produce the two following outputs (listed on the Report sheet with notes, and manually filled in correct outputs for examples)
1. Get the Report sheet to grab the email address of the agent in that row, look in Agreed Access, find an access type, then look at Current Access to see if both that email address and that access type exist there. If yes, then count it, putting the count in Column C.
2. Inversely, look at the Current Access sheet, find an email address, what access is there, and if it does NOT match what is on Agreed access, count it, putting the count in Column D.
I've tried Countifs and countifs with vlookups, so far my attempts have been so poor that Excel gives me the 'bad formula/arguments' error every time.
Bookmarks