I have a data from dataset

[Sshasnk]

I have a dataset from where I have to remove No if Yes is present for the same account code. If the account has all the No keep one No

Input:

Account ID	Value
123	No
124	Yes
124	No
124	No
121	No
123	Yes

Output:

Account ID	Value
123	No
124	Yes
123	Yes

[binuacs]

@Sshasnk One way of doing this

[FrederikE]

Hey @Sshasnk,

I think this is what you want: