how do I exclude D and A/D instances when I know the A/D/E instance is the only correct one? it's never just 3 entries per person. and there's no blank/blank/blank instance. thanks.
| Book1 | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | person | final letters | final letters condition1 | final letters condition2 | final letters condition3 | fulfill rqd? | ||
| 2 | person1 | a,c,d,h,e,x | d | y | ||||
| 3 | person1 | a,c,d,h,e,x | a | d | e | y | ||
| 4 | person1 | a,c,d,h,e,x | a | d | y | |||
Sheet1 | ||||||||
