Hi, we are trying to tidy up some data & have hit a brick wall!
Is it possible to:
i) generate all possible permutations from different strings of text that are in a single cell (separated by ";")?
ii) each permutation must include "2" of the possible strings of text (even if it's a duplicate)
iii) somehow keep track of "which permutation" it came from (either by Excel putting the different outcomes on the same row as below OR if a new sheet is generated for the results, keeping Column A as the Line ID and Column B being the outcome)
Happy to use functions or VBA
Hopefully some sample data may explain what we are trying to say a bit better!!!
Happy to (try to!) answer any questions
We are totally stumped, any help greatly appreciated!
Is it possible to:
i) generate all possible permutations from different strings of text that are in a single cell (separated by ";")?
ii) each permutation must include "2" of the possible strings of text (even if it's a duplicate)
iii) somehow keep track of "which permutation" it came from (either by Excel putting the different outcomes on the same row as below OR if a new sheet is generated for the results, keeping Column A as the Line ID and Column B being the outcome)
Happy to use functions or VBA
Hopefully some sample data may explain what we are trying to say a bit better!!!
Line ID | Possible Combination | Outcome1 | Outcome2 | Outcome3 | Outcome4 | Outcome5 | Outcome6 | Outcome7 | Outcome8 | Outcome9 |
Permutation1 | white | white / white | ||||||||
Permutation2 | white;black | white / white | white / black | black / white | black / black | |||||
Permutation3 | white;black;red | white / white | white / black | white / red | black / white | black / black | black / red | red / white | red / black | red / red |
Happy to (try to!) answer any questions
We are totally stumped, any help greatly appreciated!