Replacing text in one column that is different based on another column being the same

[Gr4c3Sult]

Hi Community,

Here is my puzzle...

If any of the same vendor IDs say No then all the other rows for the same vendor ID need to say No as well

Thank you in advance for your help 🙂

Grace

[danilang]

Hi @Gr4c3Sult 

Just to be clear, using your sample data, all the values in the campaign column will be "No" since since all vendors have at least one "No".  Is this correct?  If not, please provide the output that you require and any specific rules.

Dan

[cmcclellan · Accepted solution]

I made the new value NO so you can see the difference 🙂 

[Gr4c3Sult]

Hi @danilang 

Sorry for the confusion.  The actual data set I am using has thousands of rows with some Vendors that will be all yes and some will be all no.  There are hundreds of vendors that have a combination of yes and no and those need to be changed to all no while not changing the other vendors that have all yes and all no.

Grace

[Gr4c3Sult]

@cmcclellan,

Thank you sooo much!!!! Worked perfectly 🙂 I will be applying the logic of this workflow to many problems!  You saved me countless hours. 

Grace