So, I have a list of Yes/No questions and what I am trying to do is create a string of the terms that have a Y beside them. For example in the data below, I would like the cell to return Agitated, Angry, Depressed and I will reference that in a different part of a sheet. I would like for this to be dynamic, so if I put a 'Y' beside Apathetic, the string would read Agitated, Angry, Apathetic, and Depressed. I hope that makes sense. Here is the data:
<tbody>
</tbody>
<tbody>
</tbody>I know I could do this with a bunch of If statements stacked together, but I would love to exclude or skip the items that are blank.
Thanks in advance!!!
Mood: | Yes/No |
Agitated | Y |
Angry | Y |
Anxious | |
Apathetic | |
Depressed | Y |
Dysthymic | |
Elevated | |
Emotional | |
Fearful | |
Manic | |
Withdrawn | |
Other: |
<tbody>
</tbody>
<tbody>
</tbody>
Thanks in advance!!!