Hey,
I am trying to figure out a way to automatically create all possible conditions of the following set automatically in excel:
[TABLE="width: 320"]
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Christian[/TD]
[TD="class: xl65, width: 64"]Man[/TD]
[TD="class: xl65, width: 64"]Straight[/TD]
[TD="class: xl65, width: 64"]Black[/TD]
[TD="class: xl65, width: 64"]Able[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]Muslim[/TD]
[TD="class: xl66, width: 64"]Woman[/TD]
[TD="class: xl66, width: 64"]Gay[/TD]
[TD="class: xl66, width: 64"]White[/TD]
[TD="class: xl66, width: 64"]Mental Illness[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]Atheist[/TD]
[TD="class: xl66, width: 64"]Transgender[/TD]
[TD="class: xl66, width: 64"]Bisexual[/TD]
[TD="class: xl66, width: 64"]Asian[/TD]
[TD="class: xl66, width: 64"]Physical Disability[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"][/TD]
[TD="class: xl67, width: 64"][/TD]
[TD="class: xl67, width: 64"][/TD]
[TD="class: xl66, width: 64"]Hispanic[/TD]
[TD="class: xl67, width: 64"] [/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 320"]
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Christian[/TD]
[TD="class: xl65, width: 64"]Man[/TD]
[TD="class: xl65, width: 64"]Straight[/TD]
[TD="class: xl65, width: 64"]Black[/TD]
[TD="class: xl65, width: 64"]Able[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]Muslim[/TD]
[TD="class: xl66, width: 64"]Woman[/TD]
[TD="class: xl66, width: 64"]Gay[/TD]
[TD="class: xl66, width: 64"]White[/TD]
[TD="class: xl66, width: 64"]Mental Illness[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64"]Atheist[/TD]
[TD="class: xl66, width: 64"]Transgender[/TD]
[TD="class: xl66, width: 64"]Bisexual[/TD]
[TD="class: xl66, width: 64"]Asian[/TD]
[TD="class: xl66, width: 64"]Physical Disability[/TD]
[/TR]
[TR]
[TD="class: xl67, width: 64"][/TD]
[TD="class: xl67, width: 64"][/TD]
[TD="class: xl67, width: 64"][/TD]
[TD="class: xl66, width: 64"]Hispanic[/TD]
[TD="class: xl67, width: 64"] [/TD]
[/TR]
</tbody>[/TABLE]
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!