B
Beginner
Here is my problem:
I need to show how many days in a month a team member saw a customer. Each
day a team member could see multiple customers. I just need the number of
days per month he saw a customer. I have over 20 team members and thousands
of customers. This data runs for 10,000 rows. I can't figure this one out.
Any help is greatly appreciated!! Here is how the data is set-up:
Date Team Member Customer
1/1/2007 John Bill
1/1/2007 John Jerry
1/2/2007 John Karen
Thanks in advance!!
I need to show how many days in a month a team member saw a customer. Each
day a team member could see multiple customers. I just need the number of
days per month he saw a customer. I have over 20 team members and thousands
of customers. This data runs for 10,000 rows. I can't figure this one out.
Any help is greatly appreciated!! Here is how the data is set-up:
Date Team Member Customer
1/1/2007 John Bill
1/1/2007 John Jerry
1/2/2007 John Karen
Thanks in advance!!