Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to count unique names in a list, but only when the unique name meets a
condition (a specific title, for example) in another column. So let's say I have my list of names (many repeats) in B19:B224, and my list of titles in D19:D224. What I need to do is to count the unique names in the A column where the title is "Director", or "Vice President", etc. I can count the unique names in the A column with this formula: =SUM(IF(FREQUENCY(MATCH($B$19:$B$224,$B$19:$B$224, 0),MATCH($B$19:$B$224,$B$19:$B$224,0))0,1)) I have thus far been unable to figure out a formula that will allow me to count the unique names in the B column based on specific titles in the D column. Thanks in advance for any and all help... George |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting unique items based on date | Excel Worksheet Functions | |||
Counting unique dates based on selected criteria in a list | Excel Worksheet Functions | |||
Counting unique entries based on given condition | Excel Discussion (Misc queries) | |||
counting unique items | Excel Discussion (Misc queries) | |||
Count of unique items meeting condition | Excel Worksheet Functions |