Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF and AND statement | Excel Worksheet Functions | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If Statement | Excel Discussion (Misc queries) | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |