Hey, i have a question for a university project:
There is a sheet and i want to figure out all possible combinations if you can only pick one "Option" of A, B and C.
Thats quite easy and the result will be:
a1,b1,c1;a1,b1,c2;a1,b1,c2...
<tbody>
</tbody>
now the matter is that not all of the options of the colums can be combined e.g.: "a1 & c3" or "a2 & b2" so i want to filter out all of these "imposibble" combinations.
Is there any formula which can create the combinations from the first table without all the exceptions of a second table?
i would be very glad for any help and sorry if my question is not neccesarly precise enaugh - I am quite a beginner.
Thanks,
Valentin
There is a sheet and i want to figure out all possible combinations if you can only pick one "Option" of A, B and C.
Thats quite easy and the result will be:
a1,b1,c1;a1,b1,c2;a1,b1,c2...
A | B | C | |
1 | from the top | open | bottom |
2 | valcro | closed | top |
3 | buttons | thin line | roled up |
<tbody>
</tbody>
now the matter is that not all of the options of the colums can be combined e.g.: "a1 & c3" or "a2 & b2" so i want to filter out all of these "imposibble" combinations.
Is there any formula which can create the combinations from the first table without all the exceptions of a second table?
i would be very glad for any help and sorry if my question is not neccesarly precise enaugh - I am quite a beginner.
Thanks,
Valentin