In regards to 'y' combinations of 'n' objects; is there any quick/easy way for excel to generate and display a list of all possible combination pairings or matchings? NOTE: I don't mean display the total number of possible combinations 'y', but rather, I want to see WHAT all the possible combinations actually are.
For example: If 'n' number of objects consisted of 3 red shirts, 2 blue shirts, and 1 yellow shirt, and I wanted to know what all the possible combinations are if I can only select 2 shirts at a time,... can excel create a list of all combos displaying in such a manner like: [Red shirt #2, Blue shirt #2], [Yellow, Red shirt #1], [Blue shirt #1, Blue shirt #2], etc... ? Is that possible?
I believe this would be considered a 'Brute Force' technique.
Bookmarks