Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have data in a workbook. Each row has an admin, the admin date, and a PO.
I would like to create another worksheet that counts the number of PO per admin and sort according to Admin, PO and Month. The PO's are classified according to whether the row starts with a number or text. If it is a number it is classified as "Commercial" if it starts with text it is classified as "Residential". Below is a sample of the data: Admin Admin Date PO Michele Jenkins 10/01/07 N/A Henry Jones 10/01/07 1650 Michele Jenkins 10/01/07 1582 Henry Jones 9/21/07 8925 Kim Hu 10/11/07 6329 Kim Hu 09/01/07 1947-8615 Dennis Lowry 9/01/07 1767-8616 Dennis Lowry 10/01/07 na and the results I'm trying to automatically calculate: Sept.-C Sept.-R Oct.-C Oct.-R Michele Jenkins 0 0 1 1 Henry Jones 1 1 Kim Hu 1 1 Dennis Lowry 1 1 Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to sum multiple columns on multiple criteria | Excel Discussion (Misc queries) | |||
Multiple Criteria and Multiple Columns | Excel Discussion (Misc queries) | |||
Countif using criteria in multiple columns | Excel Worksheet Functions | |||
Multiple Criteria IF Nesting | Excel Worksheet Functions | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |