Hello there,
I've been trying to solve this for a couple days but got to nowhere. So the problem is let's say I have 2 columns, one named Group and one is Response
Group Response(Yes/No)
A
A
B
B
C
C
My goal is to create a drop list with Yes/No option for the Response columns for every row, and if I choose Yes for the first row of Group A, the second row of Group A also turn YES. Also, if I choose Yes for the second row of Group A, the first row of Group will become Yes, same ideas with Group B and C, and I have more than 1k different groups. Basically, I want to have same answers (Yes or No) within the same group, and doesn't matter which one we click first for the drop down list.
I tried to create a new sheet and used Vlookup, it worked well to return all answers as groups but it doesn't meet the requirement. They want to show the drop list on each row of the Response Column and make changes from there.
Sorry I didn't know a better way to describe this problem. I hope to get help from you all. Thank you so much!
Bookmarks