Hi. How do I get a permutation or calculate in Excel Win7, the total number of possible combinations of a fixed group of digits? Example manually counted these. 012-210=6 combos. 0123-3210=18 combos. 01234-43210=120 combos. I tried this function, have no idea if it's the correct one to use. PERMUT[number,number_chosen] but as I've never used this before, not sure how to configure it. I got these results: Edited list to exclude large invalid answers. Function:,,,Answer: =permut0,0,,,1, =permut1,0,,,1, =permut1,1,,,1, =permut2,0,,,1, =permut2,1,,,2, =permut3,2,,,2, =permut3,0,,,1, =permut3,1,,,3, =permut3,2,,,6,*? =permut3,3,,,6,*? =permut4,0,,,1, =permut4,1,,,4, =permut4,2,,,12, =permut4,3,,,24, =permut4,4,,,24, =permut5,0,,,1, =permut5,1,,,5, =permut5,2,,,20, =permut5,3,,,60, =permut5,4,,,120,*? =permut5,5,,,120,*? Why? -- I'm gradually designing a spreadsheet to solve long conundrums by Character-Digit replacement, and the DECIMAL function . Having an idea of how many rows of data will be useful for this. Also just as a new learning experience. :) Thanks, Clive. PS- As this question covers both Computer Software and Math, my hope is that either or can advise.
Sorry we are not a math solving website, we deal in product self repair and use of said products.
Testimonial: "Thank you for advice re category. I re-posted it in 'Math' rather than 'Computers', which I thought was also relevant for Excel Software. Confusing.. :)"
Sorry but I really doubt you will get an answer to this inquiry, since we work for free from home in spare time it's just to much time to compute the information, this is on you and your computer math skills.
Thank you. I've since figured it out. Excel =FACT(numberofcharacters) gives the 'factorial'. :)
×
SOURCE: EXCEL FORMULA PC
The solution I've used in similar situations is to create a 3rd column C with the items in column A and column B concatenated.
C2 = A2 & B2
C3 = A3 & B3
C4 = A4 & B4
etc.
Then use COUNTIF function: =COUNTIF(C:C,"FredRed Ball")
Hope this helps.
Was this solution helpful? Show your Appreciation by rating it:
SOURCE: what function can make a text/string BOLD?
Hi,
Try selecting a cell and right click, Format cells, Font - Bold the text the way you want it to appear in that cell and then let it be the value you want to appear when you select that cell as a solution to a "What If" statement.
I build training spread sheets that let people generate pre-programmed answers to various data entries. Answers appear like magic.
Glad to be of assistance - please rate the posting - I can learn from you.
SOURCE: Autofilter ceases to work on large Excel 2003 spreadsheet
Sounds like there is a gap between the filter heading and the column data. That's the only time I've seen suggested data missing from the drop-down.
SOURCE: Combinations and Permutations
You can enter combinations and permutations.
If the order of the selection matters (ie. 1st, 2nd, and 3rd place out of 40 contestants) use permutation. Enter:
40{shift}{nPr}3 and then [=] for your answer set (=59280 possible ways).
IF order doesn not matter (ie. a team of 3 from 40 possible members) then it is a combination. Do the same as above, but substitute {nCr} for {nPr}. (= 9880 possible ways).
For your question: a three-digit set, selecting from 0-9. There is no specified order, it is a combination. The total n=10 (there are 10 digits in the range 0-9) and you are selecting 3.
so.... 10[nCr]3 with give the number of possible combinations.
SOURCE: i want to calculate permutation and combination.
Hello,
Use the sequence [2ndF][nPr] for permutations and [2ndF][nCr] for combinations.
Exemples: 10(nPr)3 is entered as 10[2ndF][nPr]3 [=] gives 720
5(nCr)2 is entered as 5 [2ndF][nCr] 2 [=] gives 10
Hope it helps.
202 views
Usually answered in minutes!
×