I want to generate a table which contain each possible outcome of coin flipped 6 times with all sequence being covered. Each cell should result of only one toss and each row result of one possible permutation.
Why? Well I want to generate matrix along the line of attache picture and later replace max/min with values.
Capture.PNG
Last edited by AliGW; 10-26-2018 at 08:23 AM.
This is probably better suited to a VBA solution - shall I move the thread for you?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
sure. Apologies for wrong section.
Done - hope you get some help now.
What other values? If its still a binary set for each cell, that doesn't matter. If its not that drastically changes things based on the number of values you want to work with.Originally Posted by MoldyBread
If you give us all the information now, we can work on solutions that meet all your needs instead of working on solutions that only meet some of your needs and then later finding out that time was wasted and a new solution is needed from scratch.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
I didn't see the VBA thing so I'm afraid I looked at from a formulaic perspective
the below applied to matrix A1:F64 would generate the unique permutations, I think?
Formula:
Please Login or Register to view this content.
Last edited by XLent; 10-26-2018 at 10:29 AM. Reason: removed superfluous sub calc
If it helps, here's a spreadsheet I put together for generating permutationsL https://www.excelforum.com/tips-and-...thout-vba.html There are both formula based and VBA (For..Next loop) based examples. It seems that most prefer to use VBA (or other programming language) for this because generating permutations/combinations is usually a simple matter of nesting For..Next loops.
Thank you. I think my wording were extremely poor. The variable can only exist in two possible states and hence min max. I should have mentioned binomial nature.
@XLent Words perfectly. Thanks You.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks