I have a contact log file with case#, Log# and Log# among other items, I have a customer file with Case#. For each Case# I want to be able to get a count of contact events, where the count is more than 1, that happend on that logdate, in the range of that logdate and the prior 4 days (5 day count), a 10day count and an over 10 day count.
So i can report how many cases were associated with each count, knowing that there is double counting.
I want to know who is having to make multiple contacts within these time frames. subsequently I would want to know how many contacts thre were for that case# within each timeframe.
Not sure this can be solved with Excel or Excel/VBA but hoping someone out there knows how.
No file uploaded as I have nothing really to show but raw data which is restricted by my company. I have no initial solution as yet.
So i can report how many cases were associated with each count, knowing that there is double counting.
I want to know who is having to make multiple contacts within these time frames. subsequently I would want to know how many contacts thre were for that case# within each timeframe.
Not sure this can be solved with Excel or Excel/VBA but hoping someone out there knows how.
No file uploaded as I have nothing really to show but raw data which is restricted by my company. I have no initial solution as yet.