Replacing text in one column that is different based on another column being the same
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you sooo much!!!! Worked perfectly 🙂 I will be applying the logic of this workflow to many problems! You saved me countless hours.
Grace
