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
Bookmarks