Hopefully this can be done, and someong can help me get there. I'm dealing with a lot of data, and this would be very time consuming without a pivot table.
Pivot Table:
Column A: Employee Name
Pivot Table:
Column A: Employee Name
Column B: Dates worked
3/27
3/28
3/30...
Column C: Count of accounts visited on each day (Count of text)3/28
3/30...
3
7
4...
So, if the subtotal for the date range was 45 accounts visited, how can I get the average # of accounts visited per day worked. The days worked will not be consecutive, and there will be gaps for days off. 7
4...
