More sexy solutions will come in from other readers, but in the meantime here
is a quick and dirty solution.

Based on YES/NO, filter out the entries with Yes. copy them to another
location.

Based on new list of only YES entries, you can use the DATA / FILTER /
ADVANCED FILTER option to filter out only "unique records". The dialog box
has a checkbox at the end which must be activated to filter unique records.

This should give you the list. Of course this will work only one time. If
your need is to do this regularly then you may have to program it (with or
without above approach).

ciao.

"MarkN" wrote:

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