Hey,
I am trying to figure out a way to automatically create all possible conditions of the following set automatically in excel:
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
For instance, I need a category of "Christian, Man, Staight, Black, Able", "Muslim, Man, Straight, Black, Mental Illness", etc. In total there will be 324 different conditions so I would prefer to not have to manually do this. : ) I was playing around with it and thought that it may some combination of concatenate and an if/then statement, but I haven't come up with a solution. Thanks in advance for any help!
I am trying to figure out a way to automatically create all possible conditions of the following set automatically in excel:
Christian | Man | Straight | Black | Able |
Muslim | Woman | Gay | White | Mental Illness |
Atheist | Transgender | Bisexual | Asian | Physical Disability |
Hispanic |
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
For instance, I need a category of "Christian, Man, Staight, Black, Able", "Muslim, Man, Straight, Black, Mental Illness", etc. In total there will be 324 different conditions so I would prefer to not have to manually do this. : ) I was playing around with it and thought that it may some combination of concatenate and an if/then statement, but I haven't come up with a solution. Thanks in advance for any help!