Unique set of Combinations

Hello!

I am seeking help on creating a unique set of all combinations from a set of 4 data lists.

I have found examples that create the output in one column, but i'd like to keep them separated. Hopefully the example file is fairly self-explanatory, but please shout if it doesn't make sense.

I wasn't sure if the =unique function could be used with a combination of something else. The data lists are dynamic and can get quite long, so simple formulas that aren't resource intensive would be ideal.

Thanks all!

haha you are indeed correct! now i feel like a right fool, i clearly didn't realise that function worked across multiple arrays. Thanks for pointing it out!

Maybe you can help me with one more item then; is it still just as simple to apply this formula if the original data list columns aren't next to each other? (see tab 2)

cheers!

thanks for the input oeldere. However, ideally i need something that's fully automated as it will be fed with live data

Originally Posted by XOR LX

=UNIQUE(FILTER(A2:F28,{1,0,1,1,0,1}))

Regards

Thanks XOR LX!