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