Column A lists Clients, Column P lists Yes/No against the client name. Some
clients are listed more than once and some clients may have either yes or no
against their name:

John Yes
John No
John Yes
Dave No
Jane Yes

I somehow need to extract a unique list of clients where each of their
respective records is Yes. So, in the example above, I would want two records
returned, John and Jane.

Any ideas or suggestions welcome because there are a lot of records.
--
Thanks,
MarkN