Hi, maybe my title is too convoluted, so I've attached an image to showcase what I'm seeking.
This pic shows 10 words (purely for example here) and next to each word is a number indicating the series of combinations each one requires... in this case 6x total for each word resulting in 6x assorted columns.
I've used RANDARRAY in this instance for my example, but I have several issues with it. First, the formula will constantly change the order of the words in each column here instead of leaving it static. Secondly, as the words highlighted in different colors show, there are multiple instances of words adjoining each other in combinations more than once. I do not want this.
What I'm seeking is twofold:
1. Static display of uniquely combined words.
2. Each column uniquely combines every word so that the next column will never repeat any two adjoining words in the same order (see the colored highlights to reference what I'm describing here). Additionally, I also want to ensure that the first word and the last word also don't repeat (see where "ham" and "apple" are another combination that repeat).
Essentially, each column is a list that will be used for a series of rounds where each word partners with another one forming a circular loop. These words can never repeat. As such the unique combinations are understandably limited. If there is a good way to maximize the most unique columns possible with the words here then that would be a good solution.
If it's possible to create a static output, then I'd also like a way for the output to be modified - this is the reason for the numbers next to the words. Say I wanted to put 4 next to "ham" after the fact... I'd like for the output to be able to only change the combinations after the 4th column.. ie column 5 + 6 would only change in that instance.
This pic shows 10 words (purely for example here) and next to each word is a number indicating the series of combinations each one requires... in this case 6x total for each word resulting in 6x assorted columns.
I've used RANDARRAY in this instance for my example, but I have several issues with it. First, the formula will constantly change the order of the words in each column here instead of leaving it static. Secondly, as the words highlighted in different colors show, there are multiple instances of words adjoining each other in combinations more than once. I do not want this.
What I'm seeking is twofold:
1. Static display of uniquely combined words.
2. Each column uniquely combines every word so that the next column will never repeat any two adjoining words in the same order (see the colored highlights to reference what I'm describing here). Additionally, I also want to ensure that the first word and the last word also don't repeat (see where "ham" and "apple" are another combination that repeat).
Essentially, each column is a list that will be used for a series of rounds where each word partners with another one forming a circular loop. These words can never repeat. As such the unique combinations are understandably limited. If there is a good way to maximize the most unique columns possible with the words here then that would be a good solution.
If it's possible to create a static output, then I'd also like a way for the output to be modified - this is the reason for the numbers next to the words. Say I wanted to put 4 next to "ham" after the fact... I'd like for the output to be able to only change the combinations after the 4th column.. ie column 5 + 6 would only change in that instance.
