N
ngarutoa
Any suggestions for the following would be appreciated
Have a workbook with columns of data as follows:
Date | Time | ID | Division | Consultant | Client ID | Problem | Solution
Each column can have duplicates. So a client can have been contacted multiple
times re the same problem by the same consultant, sometimes on the same day
Would like a code that
- can tell me how many and which clients have been contacted for the Problem
"Crash". So if client no 7589 has had a crash should be counted as one for
the specified date range
- can tell me how many contacts all client have had in a specified date range
by the Problem reported.
TIA
ngarutoa
Have a workbook with columns of data as follows:
Date | Time | ID | Division | Consultant | Client ID | Problem | Solution
Each column can have duplicates. So a client can have been contacted multiple
times re the same problem by the same consultant, sometimes on the same day
Would like a code that
- can tell me how many and which clients have been contacted for the Problem
"Crash". So if client no 7589 has had a crash should be counted as one for
the specified date range
- can tell me how many contacts all client have had in a specified date range
by the Problem reported.
TIA
ngarutoa