Hi,
I'm running across a common problem in a survey where not more than one person in each group answered a question, and I want to be able to fill their answer across all members of the group they are in. Sometimes, however, no-one answers in a group.
In the example below (and attached), group 1 would fill with yes, group 2 with no, group 3 with yes, and group 4 would remain blank (since no one answered in that group), etc...
Any ideas how to find the answer for each group and fill to the other members?
Thanks very much!
-------
Group Answer
1
1
1 yes
2
2 no
2
3
3
3 yes
3
4
4
5
5 yes
5
5
5
6
6
7
7
7
7
8
8 no
Bookmarks