Creating multiple conditions

ehagen

New Member
Joined
Apr 24, 2017
Messages
1
Hey,

I am trying to figure out a way to automatically create all possible conditions of the following set automatically in excel:

ChristianManStraightBlackAble
MuslimWomanGayWhiteMental Illness
AtheistTransgenderBisexualAsianPhysical 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!
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Watch MrExcel Video

Forum statistics

Threads
1,095,347
Messages
5,443,925
Members
405,256
Latest member
ukboyme

This Week's Hot Topics

Top