I have a data of agents and their tests taken. I have a column of "required tests" which I want to compare to the tests taken. Then all tests in the "required tests" per agent that are NOT listed under tests taken must be listed under another column called "tests to take".
I was able to use an array formula I found in this forum to extract the needed data. But the problem is, the extraction is done per agent. Therefore, I cannot drag down to copy the formula since the index and match ranges are pointing per agent.
Can you please help me modify the formula to cover the entire range and just do the comparison per agent? Please see the screen shot below:
I also attached my excel file for your reference. I hope you can help me fix my formula.
Here is the link of my attachment:
Or I hope this one will work: