I have a call log that I need to analyze. It contains account numbers, phone number, call date, call time, contact, and call direction.
I need to either write a macro or formulas or create a pivot table to calculate the number of call/dial attempts that occur on an account per day, but only those that occur after the first contact call. If all calls on an account are non contact then I don't need to worry about them.
I also need another set of calculations that expand that from 1 day to 7 days. Calculate the number of calls that occur in a 7 day period AFTER a contact call.
Attached is a small sample of the spreadsheet that contains 40,000+ calls.
Bookmarks