Filter data by complex conditions.

Hi,

Any help on this data filtering problem I have would be much appreciated.

In the attached spreadsheet, I have data relating to 3 individuals. Column C shows their membership of four different groups “A, B, C and D”. You will see for every group that a person belongs to, a new row entry is created.

I want to be able to filter the data to show me only those individuals that are a member of A, B and C. I do not want the individuals name to appear in the filtered data if they are a member of D.

So in this example, the filter would present two records to me “Tomas” and “Harris” (or their Unique Applicant ID), because they belong to A and/or B and or C BUT NOT D.

Smith would be filtered out because although he is a member of A, B and C he is ALSO a member of D.

You will note it is possible for an individual to be a member of a group more than once. This is fine.

The real data sample has 11,000 entries. Help!

Thanks,
Terry.