Hi all,
I've the following issue: given a table with all allowed couples of values, I need to find all possible combinations among them.
For example, the couple compatibility table could be something like this:
Elem 1 - Elem 2 - Allowed?
AAAAA - BBBBB - Y
AAAAA - CCCCC - N
AAAAA - DDDDD - Y
AAAAA - EEEEE - N
BBBBB - CCCCC - N
BBBBB - DDDDD - Y
etc
I need a function/VBA macro that calculate for me all allowe concatenations
For example: AAAAA - BBBBB - DDDDD is ok, since all elements are compatible among them, instead, AAAA - BBBBB - CCCCC is not ok because AAAAA is not fine with CCCCC.
Concatenation can involve more than 3 elements (eg, 4 elemnts could be something like this: AAAAA - BBBBB - DDDDD - YYYYY)
Thank you in advance.
Ale
Bookmarks