Logit, thanks.

No, it's the other way around. sheet1 is the source data, and sheet2 is what I expect to see. I produced sheet2 by manually: filtered out those individuals who have H0004 codes along with any other codes. So, my goal is to apply formula so that I get sheet2.

Simply put, H0004 code is not allowed with any other codes
1. an individual can have all H0004 codes
2. an individual can have any other codes, but NOT along with H0004 code

Hope this helps

TIA

Regards,