Keep or eliminate duplicates in a column based on data in another column

[Rob48]

I have data that looks like the chart at bottom.  In the ‘Status’ column every row will be populated with a string that contains either ‘YES’ or ‘NO’ embedded within in it.

Every user in the list can have from 0 to 10+ instances of both ‘YES’ and ‘NO’ status, but all with have at least one.

I need to filter my data so that:

1. For any name that has only ‘NO’ statuses, I need to keep every instance of that name for later review
2. Any name that has both a ‘YES’ and a ‘NO’ status, I can eliminate all the ‘NO’ but must keep every instance with ‘YES’ for later review
3. Any name that has only a ‘YES’ I need to keep every instance for later review

I’ve started with the Summary tool doing a count of user names and keeping every name that only appears once, but from there I’m struggling with how to eliminate the ones I don’t need without also removing the ones I do.  Appreciate any help, thanks.

Name	Status
Jones	xxxYESxxzxzx
Jones	zxzxzxNOxzzzxxx
Smith	xxxYESxxxzzz
Smith	xxxzxxxxzxNOzzxzxzzzxzxz
Johnson	zzzxzzzzxzNOzzxzxzzzxzxz
Johnson	xxxzxYESzzxzxz
Johnson	zzxzxzYESzzxzxz
Johnson	xxxzxNOzzxzxz
Johnson	zzxzxzNOzzxzxz
Bailey	xxzxxxYESzzxzxz
Bailey	zxzzzzNOzzxzxz
Bailey	zxzzzzzzzYESzzxzxz
Bailey	zzxzxzNOzzxzxz
Bailey	xxxzxNOzzxzxz
Pierce	zxzzzzzzzYESzzxzxz
Pierce	xxzxxxNOzzxzxz
Pierce	zxzzzzYESzzxzxz
Pierce	zxzzzzzzzNOzzxzxz
McIntyre	xxxxNOzzzzzzzzz
Oreilly	xzxzxzxzYESzzzxzxzz
Oreilly	xxxzxNOxxzxz
Burns	xxxzxYESzzz
Burns	xNOzzxzxz
Blake	xxxzxYESzzzxzxzz
Blake	zxzzzzzzzNOzzxzxz
Blake	xxxxNOzzzzzzzzz
Blake	xzxzxzxzYESzzzxzxzz
Blake	xxxzxYESxxzxz
Blake	zxzzzzzzzNOzzxzxz

[AndrewDMerrill · Accepted solution]

You could try something like this:

[Rob48]

Thanks for this, after I played a bit with your flow I got what I needed.