jaysonsperling
New Member
- Joined
- Dec 19, 2004
- Messages
- 8
Greetings all.
I know that this topic has been handled in bits and chunks before, and I've browsed all the topics I could, but I'm curious about how to tie this all together.
I have a list of people and the logs of calls they've taken throughout a day.
I have the persons name, and thier employee ID. Each employee takes multiple calls, and each call shows up on its own line. Something like this:
CALL_TIME, AGENT_NAME, AGENT_ID
11:00, John Doe, Agent1
11:02, Jane Smith, Agent2
11:09, John Doe, Agent1
11:11, Rob Lowe, Agent3
11:13, John Doe, Agent1
11:14, Rob Lowe, Agent3
I am looking to produce something like this in a different worksheet:
AGENT_ID, CALLS_TAKEN
Agent1, 3
Agent2, 1
Agent3, 2
If anyone would be able to help, or point me in the right direction, it would be awesome, and greatly appreciated.
Thanks all for any help
I know that this topic has been handled in bits and chunks before, and I've browsed all the topics I could, but I'm curious about how to tie this all together.
I have a list of people and the logs of calls they've taken throughout a day.
I have the persons name, and thier employee ID. Each employee takes multiple calls, and each call shows up on its own line. Something like this:
CALL_TIME, AGENT_NAME, AGENT_ID
11:00, John Doe, Agent1
11:02, Jane Smith, Agent2
11:09, John Doe, Agent1
11:11, Rob Lowe, Agent3
11:13, John Doe, Agent1
11:14, Rob Lowe, Agent3
I am looking to produce something like this in a different worksheet:
AGENT_ID, CALLS_TAKEN
Agent1, 3
Agent2, 1
Agent3, 2
If anyone would be able to help, or point me in the right direction, it would be awesome, and greatly appreciated.
Thanks all for any help