'FACT function' category



How to use the FACT function
What is the FACT function? The FACT function returns the factorial of a number. What is the factorial of a […]
List permutations with repetition and how many to choose from
This article demonstrates a macro that lets you create a list of permutations, repetitions are allowed, based on a number […]
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 […]
Return all combinations
Today I have two functions I would like to demonstrate, they calculate all possible combinations from a cell range. What […]
Create permutations [UDF]
Chris asks: Maximum Number Allowed is 4 digit and the number is from 0 to 9. After I fill in […]
List permutations no repetition [UDF]
This blog post describes how to create¬†permutations, repetition is NOT allowed. Permutations are items arranged in a given order meaning […]
List permutations with repetition [UDF]
This blog post demonstrates a custom function (UDF) that creates¬†permutations. Repetition is allowed. The custom function lets you specify the […]

Excel categories