Forum Discussion
Formula that output values of all possible permutations
simones7982 Is it possible to upload a copy of the sheet? You'd be far more likely to get the help you're seeking if you could supplement your very thorough description with the spreadsheet in question.
It's hard to visualize what you're saying, and we'd have to create our own version in order to help....you can greatly facilitate that, and make it more accurate in the process, by showing us what you're working with.
mathetes You are totally right. It would be easier to try to help me if I share the spreadsheet.
I have noticed I have made some mistakes when I described the spreadsheet. Please find attached the correct spreadsheet. I have also reformulate the question of what I am trying to achieve in the first tab.
Thank you for your help
- That's going to take some time, which I don't have right now. I hope there's no rush; or that someone else will feel free to jump in. It's an intriguing problem, I will say. Just need time to contemplate....