Remove all records from each group when all records in group are not of a certain type(s)

[hk106]

Hi,

I have a recordset that looks something like this:

Group-----Type
1A----------F
1A----------G
1B----------C
1C----------B
1C----------B
1C----------F
1C----------T
1D----------F
1D----------F
1D----------G

Basically, I only want the records in which the group contains only F and G for the Type. So in this example, I would only have:

Group-----Type
1A----------F
1A----------G
1D----------F
1D----------F
1D----------G

Please let me know if this doesn't make sense. I greatly appreciate any help on this.

Thank you.

[hk106]

***bump***

[haru]

I figure that group and type are in separate columns. So highlight your entire section, go to the Data ribbon, click on Filter.
Next click on the filter icon next to "Type" in your table, uncheck "select all", check boxes for F and G, click on "ok".