Hi Guys n Girls,
Can you please have a look at the attached file, I am unable to sort out the right formula.
The "Availability" Sheet will have about 4000 lines of data from 1 September 2009 through to today. The data will consist of all the call center reps I have under me.
The Daily_Report Sheet has the bulk of thier results but is missing the "After Call" in Column E on the "Availability" Sheet.
I need a formula that will look at Column A & B of "Daily_Report" and find the match on "Availability" (Agents Name and matching date).
When it has found the match i need it to display the corresponding result in "Activity" Column D, known as Activity Summary - Total Time.
I hope this explanation is sufficient, If not however please ask me any questions!!!