Is there a formula in excel to give all possible combinations of a number? - all the possible combinations of a four digit lock
Is there a formula in Excel for all combinations of letters possible choice of 4 at any time, for example +, A, AB +, B, B, C +, C, C-, D + D DE + E E-(A +, ie, A +, A +, A +)
Thursday, January 7, 2010
All The Possible Combinations Of A Four Digit Lock Is There A Formula In Excel To Give All Possible Combinations Of A Number?
1 comment:
Want to know how many there are, or want to know what they are. In the first case, only 18 ^ 4 (104976) will assume that 18 letters to score points.
There is no formula for generating the sequence and timing information generated for many hands. However, you can write a macro to do this. However, you need a new version of Excel use - older versions are limited 65,536 cells per sheet.
On the other hand, it looks like a mechanism to solve the reported problems. It can be a very good mechanism. Why can not the real problem, we try to make do in their place?
Update: As mentioned above, there are 104,976 different combinations. It is convenient to deal with this number of combinations.
Post a Comment