| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count unique with mulitple criteria
I have a list of data.
Mike JOB1 Karen JOB2 Unfilled JOB1 Unfilled JOB2 Unfilled JOB1 Alex JOB1 Alex JOB1 I want to count the unique person that works on a job, however "unfilled" always denotes a new person and therefore I do not want it to be unique. eg. searching for "JOB 1" should give me 4 because i do not want to count Alex twice but I do want to count Unfilled twice. Any help appreciated, Ellen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria | Excel Worksheet Functions | |||
| how to count unique values in excel based on multiple criteria | Excel Worksheet Functions | |||
| How do I count wildcard text meeting certain criteria in EXCEL? | Excel Worksheet Functions | |||
| Count of unique items meeting condition | Excel Worksheet Functions | |||
Threaded Mode
