Archive for FACT function
The FACT function returns the factorial of a number. Formula in cell C3: =FACT(B3) Example, 3! = 3*2*1 = 6 […]
List permutations with repetition and how many to choose from
Noel asks: Is there a way where i can predict all possible outcomes in excel in the below example. Total […]
Permutations with and without repetition
I discussed the difference between permutations and combinations in my last post, today I want to talk about two kinds […]
Today I have two functions I would like to demonstrate, they calculate all possible combinations from a cell range. What […]
Select numbers in each permutation
Chris asks: Maximum Number Allowed is 4 digit and the number is from 0 to 9. After I fill in […]
List permutations without repetition [UDF]
This blog post describes how to create permutations. Repetition is NOT allowed. VBA code: How to implement user defined function in […]
List permutations with repetition [UDF]
This blog post describes how to create permutations. Repetition is allowed. Vba code: Function ListPermut(num As Integer) 'Permutations with repetition […]
