create a unique list based on a specific phrase

Hi again,

I am trying to create a list that has unique values (again).

I need specific information returned in a created list that is unique to the Value and based on the Description field.

There can be duplicate Values each with varying Descriptions. When ALL the same Values have the Description equal to "Yes, it will work.", the returned list should return "Yes, it will work." Otherwise, i dont care what goes into the cell as long as it isnt "Yes, it will work."


I have some fake data (on the left), with the created list (on the right) with what it should contain.

Thanks for all the help!
Joanne