Hi Gary's Student,

I should have mentioned in my previous post that we have already tried pivot
tables and they do work, but this drill is part of a larger model, and the
pivot tables are too unwieldy for use in this project. That's why we're
trying to construct the formula. If the formula returns an accurate result,
that result will be picked up elsewhere in the model and used for other
calculations.

"Gary's Student" wrote:

Have you tried a Pivot Table? It can give you a count of all unique names
organized by title.
--
Gary's Student


"George Lynch" wrote:

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