In my Excel spreadsheet I am trying to figure out a formula to combine an
examiner's initials with a specific date in which a record was audited.
For Example, part of my spreadsheet looks something like this:
Date
Examiner Audited
ds 04/03/07
ds 04/03/07
ds 03/31/07
tc 03/31/07
tc 03/29/07
hr 04/04/07
At the bottom of my spreadsheet I want to provide a brief summary on how
many audits were made by each examiner on a specific date.
ds would have 2 on 04/03/07, I want the intials of the examiner and the date
with a count of the date.
I have a large spreasheet, this is just two columns out of many. Appreciate
any help!
JS